checkbox issue..

[Bob2]

Hi

I loop through a recordset to display whats in a shopping basket, besides a product description and qty I also have a checkbox option. This checkbox is checked if the value from the database is set to 1. But I can't get the update procedure on that checkbox to work. How can I trigger the update to change the value depending on if the user check or clear that checkbox?


/M

 

[mattygriff]

You need to check the value of the checkbox which will be either "on" or "off".

You can then set the value of your database field to be either 1 for "on" or 0 for "off".

 

[Bob2]

Hi

Got it working now, thanks for your help!

/M

 

[DreXor]

if you are using a form with no default values for the checkbox, you might also want to add a hidden input with the names of all the checkboxes in the form in order to verify and account for the ones that weren't checked or unchecked, because an unchecked checkbox returns a zero length string in a request.