>I'm trying to post data from an html form using asp. I have a checkbox that I want to update a logical field in the foxpro table. Every time I try to insert a value I get the "invalid data type" error.
>
>I've tried to convert the value using cbool(), no luck. Help.
The form post will send the checkbox value as character. I just use a condition to set the value passed.
'Client form with checkbox being posted
<INPUT TYPE=CHECKBOX NAME=CB1 VALUE="Y">
'On server ASP being posted to:
CB1=Request.Form("CB1")
If CB1="Y" then
CB1=true
else
CB1=false
end if
'Now simply update your logical field in the recordset with CB1
Michael McLain