Checkbox value to DB???

I'm trying to learn ASP and have a simple problem in regard to some code I'm doing for an update-page:

In one file I feed a recordset with the boolean values from db-field Any_answer (true/false). The variable check_var is set to this value:

<%      
     check_var = CBool(rsEdit("Any_answer"))
     If check_var = TRUE then %>
     <input type="checkbox" name="reply" value="true" checked>
<% Else %>
     <input type="checkbox" name="reply" value="false">
<% End If %>


This works fine. But then, in the other file (the form is calling), I want to update the checked/unchecked value to the db:


rsUpdateEntry.Fields("Any_answer") = CBool(Request.Form("reply"))


Every other field I update works perfectly - they are all strings. But the true/false values seem to disappear when I try to update the field again. Does anyone know what to do?

Chris

Chris, here is the first part of your code:

<%check_var = CBool(rsEdit("Any_answer")) %>
     <input type="checkbox" name="reply" value="true"<%If check_var = TRUE then response.write " checked"%>>

I.e. value of checkbox works if checkbox was checked. Then, insert below following code in second file (the form is calling) before SQL update statement:

<%

Dim sReply
If Request("reply")="true" Then
   sReply=1
Else
    sReply=0

End If

%>

And insert this "sReply" as value for Any_answer field, so in case checkbox is checked and it's value = "true", then sReply=1. Else, sReply will be eq. to 0.

Good luck!

Dude, there's nothing to do with database, I didn't even asked you the type of DB :)

I'm not really sure, but Yes/No might also work for Access.

b_bonnett, I used MS Access extensivly, before I switched to SQL server, so I can assure you, Yes/No works in Access just fine. But anyway, question was about vbscript, not DB :)