>Then we 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 + "'"
>
>
In VB single quote starts the comment, although I think it should be ignored when it's a part of the string variable. Also, why do you have & and plus?
You need to have either + or & but not both of them.
If it's not broken, fix it until it is.
My Blog