Trim() Adds Doubles Apostrophes in CFQuery

<h1>Trim() Adds Doubles Apostrophes in CFQuery</h1>
<p><a href="https://bugbase.adobe.com/index.cfm?event=bug&amp;id=3585643" target="_blank">https://bugbase.adobe.com/index.cfm?event=bug&amp;id=3585643</a></p>

<p>Please test this code using your ColdFusion server or <a href="http://cflive.net/" target="_blank">CFLive (CF &amp; Railo)</a>.</p>

<style type="text/css">
#testResults li {color:#090;}
#testResults li.bad {color:#f00;}
</style>

<cfset testCont = " This isn't my test ">
<CFSET Expected = ArrayNew(1)>
<CFSET Test = ArrayNew(1)>

<cfscript>
function trim2(i){
    return trim(i);
}
</cfscript>

<cfset ArrayAppend(Expected, "Trim = #Trim(testCont)#")>
<cfset ArrayAppend(Expected, "Left = #Left(testCont, LEN(testCont)-2)#")>
<cfset ArrayAppend(Expected, "Right = #Right(testCont, LEN(testCont)-2)#")>
<cfset ArrayAppend(Expected, "JSString = #JSStringFormat(testCont)#")>
<cfset ArrayAppend(Expected, "LCase = #LCase(testCont)#")>
<cfset ArrayAppend(Expected, "UCase = #Ucase(testCont)#")>
<cfset ArrayAppend(Expected, "LJustify = #LJustify(testCont,15)#")>
<cfset ArrayAppend(Expected, "RJustify = #RJustify(testCont,15)#")>
<cfset ArrayAppend(Expected, "LTrim = #LTrim(testCont)#")>
<cfset ArrayAppend(Expected, "RTrim = #RTrim(testCont)#")>
<cfset ArrayAppend(Expected, "MID = #MID(testCont,5,8)#")>
<cfset ArrayAppend(Expected, "RepeatString = #RepeatString(testCont,3)#")>
<cfset ArrayAppend(Expected, "Wrap = #Wrap(testCont,5)#")>
<cfset ArrayAppend(Expected, "XmlFormat = #XmlFormat(testCont)#")>
<cfset ArrayAppend(Expected, "ToString = #ToString(testCont)#")>
<cfset ArrayAppend(Expected, "JavaCast = #JavaCast('string', testCont)#")>
<cfset ArrayAppend(Expected, "SerializeJSON = #SerializeJSON(testCont)#")>
<cfset ArrayAppend(Expected, "UDF = #Trim2(testCont)#")>

<CFSET TestQuery = QueryNew("Field1,Field2","Integer,Integer")>

<cfquery name="GetDetail" DBTYPE="query">
    SELECT * FROM TestQuery
    <cfset ArrayAppend(Test, "Trim = #Trim(testCont)#")>
    <cfset ArrayAppend(Test, "Left = #Left(testCont, LEN(testCont)-2)#")>
    <cfset ArrayAppend(Test, "Right = #Right(testCont, LEN(testCont)-2)#")>
    <cfset ArrayAppend(Test, "JSString = #JSStringFormat(testCont)#")>
    <cfset ArrayAppend(Test, "LCase = #LCase(testCont)#")>
    <cfset ArrayAppend(Test, "UCase = #Ucase(testCont)#")>
    <cfset ArrayAppend(Test, "LJustify = #LJustify(testCont,15)#")>
    <cfset ArrayAppend(Test, "RJustify = #RJustify(testCont,15)#")>
    <cfset ArrayAppend(Test, "LTrim = #LTrim(testCont)#")>
    <cfset ArrayAppend(Test, "RTrim = #RTrim(testCont)#")>
    <cfset ArrayAppend(Test, "MID = #MID(testCont,5,8)#")>
    <cfset ArrayAppend(Test, "RepeatString = #RepeatString(testCont,3)#")>
    <cfset ArrayAppend(Test, "Wrap = #Wrap(testCont,5)#")>
    <cfset ArrayAppend(Test, "XmlFormat = #XmlFormat(testCont)#")>
    <cfset ArrayAppend(Test, "ToString = #ToString(testCont)#")>
    <cfset ArrayAppend(Test, "JavaCast = #JavaCast('string', testCont)#")>
    <cfset ArrayAppend(Test, "SerializeJSON = #SerializeJSON(testCont)#")>
    <cfset ArrayAppend(Test, "UDF = #Trim2(testCont)#")>
</cfquery>

<CFOUTPUT>
<ol id="testResults"><CFLOOP FROM="1" TO="#ArrayLen(Expected)#" INDEX="this"><CFSET isBad = Expected[This] NEQ Test[This]>
<li<CFIF isBad> class="bad"</CFIF>>#Expected[This]#<CFIF isBad> (#Test[This]#)</CFIF></li></CFLOOP>
</ol>
</CFOUTPUT>