Hi!  Sorry to bother you guys again but my project is almost done and I have come across a small problem...

Users fill out a form, the contents of which are verified and then written to an Access Database.  One of the objects is a checkbox.  It is asking the user wether or not they wish to receive a newsletter.  In the database, the column for 'newsletter' is in the data type 'yes/no' but I don't know how to write wether it was checked or not into the database.  Can Anyone help?

This is what i have so far for the text fields....

rs("username")=username
rs("password1")=password1
rs("fullname")=fullname
rs("email")=email
rs("location")=location
rs("birthday")=birthday
rs("birthmonth")=birthmonth

I tried rs("newsletter")=newsletter for the checkbox but I got a data mismatch error. 

I'd be really grateful for any help you could give me!  I appreciate what you guys do for us amateurs!

Loadsa love,
Vicky  xxx

 

try IF newsletter = "yes" THEN

newsletter = True

Else

newsletter= False

END IF

rs("newsletter")=newsletter

Thanks!!  It's almost working now!  I don't get any errors anymore but when i open the database, boxes that should be checked aren't.

Any idea wots going wrong?

Thanks again!!

Loadsa love,
Vicky  xxx

I recoment not using the checkboxes in the database.

for a check box I just do this

<%
IF checkbox = "true" Then
SQL = "UPDATE config SET newsleter = 't' WHERE DBID ="& User
    Set RS = DBConnection.Execute(SQL)

ElseIF checkbox = "false" Then
SQL = "UPDATE config SET newsleter = 'f' WHERE DBID ="& User
    Set RS = DBConnection.Execute(SQL)

Else

End IF
%>

Then to to pull the data back out of the database just do this.

<%
SQL = "Select * From newsleter Where DBID ="& user 
      Set RS = DBConnection.Execute(SQL)

      newsleter=RS("newsleter")
%>

Yes<INPUT TYPE="radio"  NAME="news" VALUE="true" <%IF newsleter= "t" Then%>CHECKED<%Else%><%End IF%>>
No<INPUT TYPE="radio" NAME="news" VALUE="false" <%IF newsleter= "f" Then%>CHECKED<%Else%><%End IF%>>

Hope that helps