Unable to pass boolean value to database
Posted on 2006-07-13
I'm using vbscript in an HTML page to append a record to a database. One of the fields on the form is a checkbox and I use the following form validation:
form18 = main.TUSER.value
If main.TUSER.Checked Then
form18 = "YES"
form18 = "NO"
I know the 'if statment' works because it populates the correct information in an alert box... However, I get 'data type mismatch in criteria expression' error upon appending a record. I've checked the db and the field is set up as boolean. Yes/no's actually show in the field in the database instead of checkboxes. Is there another setting that I may be missing? I've assigned a 500 point value due to urgency. Thank you!