When I change the quotes as you suggest we then get the following error

Microsoft VBScript compilation error '800a03ea'

Syntax error

/snworld/newsite/Global/DetailPublicVerify.asp, line 25

Recordset1.Source = "SELECT * FROM datahistory where Docket_No = '" + & HAWB + "'"

Isn't that a syntax error?

Thanks

Colin




>Use VFP OleDB.
>
>>>This doesn't answer your question, but why are you using both ODBC and OLEDB?
>>>
>>>>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?
>>
>>Craig
>>
>>I'm not the web programmer - which should I be using for a VFP table?
>>
>>Colin