http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T07:02:35 en-us http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa53.htm#33229 Mike, what you describe as a bug in the way PreserveSingleQuotes() works in queries is actually a feature. One of the reasons it exists is to allow one to generate SQL code on the fly and embed it into a query. hereticmessiah 0 0 2005-05-10T10:28:16 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa53.htm#29559 preserveSingleQuotes() also has an issue taking the output of a function call as well. Which when compounded with the fact that function call output doesn't get escaped in a cfquery (see cfquery comment I made) this presents a coding nightmare. Mike@Jobscience 0 0 2005-03-11T15:20:03 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa53.htm#9999 in the example:<br /><cfset list0 = " '1','2''3' "><br />is missing a comma between 2 and 3 MFI 0 0 2004-03-07T08:37:11 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa53.htm#5124 There appears to be a parsing problem in parsing PreserveSingleQuotes<br>This has been submitted as ColdFusion Bug number 53977. halL 1 1 2004-01-13T06:30:02 http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functa53.htm#5119 preserveSingleQuotes seems to not like complex variables as arguments. Consider this code<br /><br /><br /><cfscript><br /> foo = structNew();<br /> foo.key1 = "value1";<br /> foo.key2 = "value2";<br /></cfscript><br /><br /><cfloop collection="#foo#" item="key"><br /> <cfoutput><br /> #key# = #foo[key]#<br /><br /> </cfoutput><br /></cfloop><br /><hr><br /><cfloop collection="#foo#" item="key"><br /> <cfoutput><br /> #key# = #trim(foo[key])#<br /><br /> </cfoutput><br /></cfloop><br /><hr><br /><cfloop collection="#foo#" item="key"><br /> <cfoutput><br /> #key# = #preserveSingleQuotes(foo[key])#<br /><br /> </cfoutput><br /></cfloop> nathandintenfas s 0 0 2004-01-12T15:05:20