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: Incorrect syntax near
'l'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (75:1) to (75:65).
Anyone know how to work around this? You help would be appreciated.
Dave Clay
Trusjoist.com
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
