-snip-
>Finally. IMHO, the:
>Microsoft OLE DB Provider for SQL Server error '80040e14'
>Incorrect syntax near the keyword 'order'.
>/creditrecords/ViewCartDetail.asp, line 41
>
>it's becuase StrConn since it works locally. In SQL the word NEAR really means BEFORE so it can be more than that even an empty query result.
>
>

You mean strSQL. A problem on strConn would mean the connection has not been established so you could not have gotten this response from the server.

Cheers,