data type mismatches
I am at a loss with these two errors.
I am writing a form with over 40 fields that are written to a an access 2000 db in asp classic.
I am having problems with two types of data types: boolean and dates
In Access the fields are:
name: flexible, data type: yes/no
name:startdate1, data type:date (short date)
The form:
<input name="activityFlex" type="checkbox" id="activityFlex" value="True">
<input name="startTime1" type="text" id="startTime1">
ASP:
Flexible=trim(request.form("activityFlex"))
StartTime1=trim(request.form("startTime1"))
Writing to the db using the recordset:
rsAddActivity.addnew
rsAddActivity("Flexible")=Flexible
rsAddActivity("StartTime1")=StartTime1
rsAddActivity.Update
I get errors at the :
rsAddActivity("Flexible")=Flexible
rsAddActivity("StartTime1")=StartTime1
- both lines give me errors that is as follows:
Error Type:
Provider (0x80020005)
Type mismatch.
Can anybody help me? I have tried delimiting (#date#) and CInt(date)and have tried true, yes and 1 for the boolean.
Thanks,
Luis
|