Re: Insert statement using '#session.arrBasketLit[Request.idx][3]#',

I had a similar problem recently and fixed it by setting a new variable... eg: It seemed to escape the single quote... good luck At 11:59 AM 5/9/02 -0600, you wrote: >When using the Request.idx session variable, and the variable has an >apostrophe in a string, it creates the following error.

Insert statement using '#session.arrBasketLit[Request.idx][3]#',

When using the Request.idx session variable, and the variable has an apostrophe in a string, it creates the following error. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 21: Incor