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



-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

This is a Math problem not an asp problem. Anyway.

Dim iCheckCount
Dim iScore
Dim iFinalScore

iCheckCount = 'Number of checkboxes checked
iScore = 'Total Score to be distributed

iFinalScore = CINT(iScore) / CINT(iCheckCount) 'This tells you how many counts each ROW gets
iFinalScore = iFinalScore / 3 'This tells you how many counts each column in each ROW gets

This is problematic because you are using integers, Given 30 as the count and 3 check boxes checked each column in each Row should get 3.333333 votes (10 / 3) soo since you are storing as integers this should actually get cast to just 3 resulting in only 9 votes being cast per row as opposed to 10. You will need to figure out how you want to deal with this.


-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature