How to use Checkbox in ASP?

[longmatch]

I just designed a webpage using ASP, this page is connected to an ACCESS database. there are several checkboxes in this page. When I send the data to my database, it always gives me the error message for MISMATCH. I do not know why. I know when checkbox is checked, it sends "on" to server, nothing otherwise. How to handle this kind of question?

Thank you

Haijun

 

[Ovatvvon]

It may be your checkbox...it may not. Evaluate your entire sql string to be sure.

If it is, be aware check boxes, access databases and sql server db's usually act different with different values. Some (generally the web) works with "on" for checked or "off" or nothing when it's not checked. Access I believe usually likes true or false, and sql server usually likes 1 or 0 (zero).

Try different combinations and/or values for the input. -Ovatvvon :-Q