Thanks Naomi
I'll get my web programmer to check it out
Colin
>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?
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing