If Docket_No is a character field, you need to include single quotes in the code, e.g.
where Docket_No = '" + & HAWB + "'"
>It looks like error comes from 'WHERE docket_no = ...'. What is field type for docket_no and what is the value of HAWB at the time of error?
>
>
>set Recordset1 = Server.CreateObject("ADODB.Recordset")
>
>Recordset1.ActiveConnection = MM_Global_STRING
>Recordset1.Source = "SELECT * FROM datahistorytemp WHERE docket_no = " & HAWB
>
>Recordset1.CursorType = 0
>Recordset1.CursorLocation = 2
>Recordset1.LockType = 3
>Recordset1.Open()
>
>>
>>I've sent code as attachment to your email address as I got errors when I tried to copy and paste it into UT - and I don't have a current subscription - should have by the end of the week
>>
>>Colin
>>
>>>Can you post all relevant code?
>>>BTW, MM_Global_STRING is a connection string not Recordset definition.
>>>
>>>>Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
>>>>
>>>>[Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch.
>>>>
>>>>The offending ASP line reads
>>>>
>>>>Recordset1.Open()
>>>>
>>>>This is the recordset definition
>>>>
>>>>MM_Global_STRING = "Driver={Microsoft Visual FoxPro Driver}; SourceType=dbf; SourceDB=W:\Webspace\resadmin\BobRose\dolphinfactory.com\www\snworld\newsite\Global\DataHistoryTemp; Exclusive=No; BackgroundFetch=No;"
>>>>
>>>>Any ideas?
If it's not broken, fix it until it is.
My Blog