The problem there is just the opposite: I believe that BIF was introduced to get around the fact that CF escapes single-quotes output from variables, so that you can build complex statements as text strings and output them without doubling value-internal single quotes.
I think I'll try rob's suggestion of <cfqueryparam> use. Hopefully it won't matter that I'm grabbing the value via an accessor. -- Eric C. Davis Programmer/Analyst I Georgia Department of Transportation Office of I.T. Applications Web Applications Group 404.463.2860.199 [EMAIL PROTECTED] -----Original Message----- From: Gabriel Roffman [mailto:[EMAIL PROTECTED] Sent: Monday, December 29, 2003 1:04 PM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] Accessors, SQL, and quotes Wouldn't you just use the PreserveSingleQuotes function within your SQL calls? <cffunction name="testQuotes"> <cfquery name="sqTest" datasource="myDSN"> INSERT INTO myTable (noquotes, quotes) VALUES ('#PreserveSingleQuotes(getNoQuotes())#', '#PreserveSingleQuotes(getQuotes())#') </cfquery> </cffunction> </cfcomponent> ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
