L
Les Juby
Getting really stumped here.....
Using Classic.ASP and after an editing page has been completed I need
to write the values back to an Access 2000 database. But I'm battling
with a checkbox resultwhich has to be stored in aYes/No field.
I'm testing the variable no_mail to see if it returns "on" in ASP
which means the checkbox is ticked. I then load a variable called
sql_val_no_mail with the text that the SCP statement will use to
update into Access.
ie.
If no_mail = "on" Then
sql_val_no_mail = "Yes"
and then.....
" no_e-mail='" & sql_val_no_mail & "',"
goes into the SQL string
But what do you feed into Access for the Yes/No field to record a
positive
Tried: Yes "Yes" True "True" 1 "1" 0 "0" on
Any suggestions, please.....
thanks
.les.
Using Classic.ASP and after an editing page has been completed I need
to write the values back to an Access 2000 database. But I'm battling
with a checkbox resultwhich has to be stored in aYes/No field.
I'm testing the variable no_mail to see if it returns "on" in ASP
which means the checkbox is ticked. I then load a variable called
sql_val_no_mail with the text that the SCP statement will use to
update into Access.
ie.
If no_mail = "on" Then
sql_val_no_mail = "Yes"
and then.....
" no_e-mail='" & sql_val_no_mail & "',"
goes into the SQL string
But what do you feed into Access for the Yes/No field to record a
positive
Tried: Yes "Yes" True "True" 1 "1" 0 "0" on
Any suggestions, please.....
thanks
.les.