I had a similar problem recently and fixed it by setting a new variable... eg: <cfset insertstring=request.idx>
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. > > 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 > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
