Hi - I have a check on my form that I am getting the follow error upon submit:

Provider error '80020005'

Type mismatch.

In my code as below:

objRS("married") = Request.Form("married")

Can anyone tell me whats wrong ?

Thanks

I assume it's vbscript, it may be a typecast problem due to all variables are var by default and Record Sets are not, do a type cast and see if that works, example
see if that works at all...

checkboxes return either 1 (checked) or 0 (unchecked)...depending on what your doing with it (like inserting the info into a database) you would have to verify that the "married" field is an integer data type, or convert the 1 or 0 to a string as suggested above.

Hi - still have some problems with this.....

In my code I am using: objRS("married") = Cstr(request.form("married"))

And in my db which is an access 2000 I have tried setting the field value to either Yes/No or a OLE field

Both give me the error below:

Provider error '80020005'

Type mismatch.

/wills_questionnaire.asp, line 40

Any idea's appreciated !

you'll have to manipulate the data.
If the checkbox returns 1 (its checked) you can't insert a 1 into a Yes/No field so you'll have to change it to a yes or no according to what the checkbox is returning

Another question... complete newbie

I have about 20 check boxes on my form, dont know how to incorporate all the else / end ifs......

Can you help - many thanks..

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

objRS("married") = Cstr(request.form("married"))
objRS("children") = Cstr(request.form("children"))
objRS("pets") = Cstr(request.form("pets"))

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If(Request.Form("married") = 1) then
married = "Yes"
Else
married = "No"
End If

INSERT INTO TABLE VALUES('" & married & "')

do all the ifs first and then do one insert at the end.
then just do that for each checkbox.

at the end, do the insert