Hello, I am facing a problem in ASP. The scenario is... I have a database with the following Colums and the data type of all Colums are integer id|score1 | score2 | score3 ------------------------------------ 1 | 10 | 4 | 10 | 2 | 5 | 51 | 10 | 3 | 5 | 22 | 10 | 4 | 15 | 54 | 10 | 5 | 7 | 11 | 10 | 6 | 19 | 2 | 10 | 7 | 10 | 1 | 10 | 8 | 12 | 66 | 10 | 9 | 3 | 75 | 10 | 10| 7 | 11 | 10 | Now, I have a page (search_result.asp) where I can search for scores based on the ids, and each result has a corresponding checkbox (so that I can increase the number of score of a particular ID or multiple IDs ) I have a second page (update_scrore.asp) where I have 3 textboxes where I can enter scores and at the click of a button these scores are added to the selected ID. I can make it work perfectly fine when It comes to just one score update at a time. But I cannot figure out how to add the score if I am selecting multiple checkboxes i.e. multiple IDs. For Eg. If I am selecting the checkbox containing the ID 8, and I want to add 30 scores in each 3 colums, the updated value will be 42 | 96 | 40 But I cannot figure out, how should I add and update the colums If I am selecting multiple IDs i.e. 7, 5, 9 I am new to ASP, so please help. Thanx in Advance.... God Bless
well you could check and see if the number parameter is not empty, so if lets say an input with a name id8 is not empty then add it if it is empty don't add it, place the code so that it'll be easier for us