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?