Good find guys...entered as issue #52305 and currently targeted for RedSky.  

Note that a possible workaround that might work for you is to separate trim and 
cfqueryparam trim:

<cfset string2="#trim(string)#">

<cfquery datasource="#dsn#" name="qTest"> 
SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="#string2#"> AS test 
</cfquery> 

<cfdump var="#qTest#" label="5">
<cfoutput query="qTest">[#test#]</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to