Dave Watts wrote: >>Anyone else notice how string functions still flub up in >>queryparams when using 6.1? Wiggity-wack y'all! > > Can you give an example?
Run the following template. All the outputs should be the same, but they are not. <cfset dsn="exampleapps"> <cfset string = "test ' test"> <cfquery datasource="#dsn#" name="qTest"> SELECT '#string#' AS test </cfquery> <cfdump var="#qTest#" label="1"> <cfoutput query="qTest">[#test#]</cfoutput> <cfquery datasource="#dsn#" name="qTest"> SELECT '#trim(string)#' AS test </cfquery> <cfdump var="#qTest#" label="2"> <cfoutput query="qTest">[#test#]</cfoutput> <cfquery datasource="#dsn#" name="qTest"> SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="#string#"> AS test </cfquery> <cfdump var="#qTest#" label="3"> <cfoutput query="qTest">[#test#]</cfoutput> <cfquery datasource="#dsn#" name="qTest"> SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="#trim(string)#"> AS test </cfquery> <cfdump var="#qTest#" label="4"> <cfoutput query="qTest">[#test#]</cfoutput> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
