check box update in database

[olegflute]

Can somebody help me with the code. I retrieve dynamically records (shop items) from the database and the check boxes next to each item. The values of the check boxes are retrieved dynamically as well (yes/ no, depends if products exists). Then I select or deselect the check boxes (items) that I want and click the update button. The next page update the check boxes fields in the database. I suppose I have to use item ID in check box’s VALUE field and some loop through check boxes collection, right?

 

[shaddow]

Use the id as value and same name for checkboxes
and then on the server you can update fields right they are.

fields=Request("myCheckBoxName&quot
"UPDATE myTable set myField=false" - first querry and then
"UPDATE myTable set myField=true where myID in ("& fields &&quot"

This should do it, since the fields it's an comma separated string.
fields could be something like this
1,10,14 or just 1 or 1,23,45,67,100... etc
the IN operator expects just the same format for the enumeration.

________
George, M