Docket_No ='" + Hawb + "'"
assuming Hawb is a character value also.>>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() >>>>>>>