ms-access database

[gudipati]

hi
i am using ms-access database with yes/no field to checkbox.
i have the form if i select the check box in webform it should be check in database
checkbox field.how can i handle this.pl guide me

[Ranjan kumar Barik]

hi
i am using ms-access database with yes/no field to checkbox.
i have the form if i select the check box in webform it should be check in database
checkbox field.how can i handle this.pl guide me

If you are talking about inserting checked values to the database, then you have to get the value of the check box, you have given ( it must be same that you want to insert into the database) and insert into your database.
OR
If you want to connect to database when check Box is checked then just put the connection code inside a conditional loop and execute it as per the check box is selected or not

[markrawlingson]

Your update would look like this..

<%
If Request.Form("sCheckBox1") = "on" Then
   rs("yes_no_field") = 1
Else
   rs("yes_no_field") = 0
End If
%>
 

Sincerely,
Mark