Damon Cooper wrote: > What's the issue you're seeing with CFQUERYPARAM in CFMX?
All 4 queries below should return the same value, but the last one returns a string with 2 quotes. <cfset string = "test ' test"> <cfquery datasource="test" name="qTest"> SELECT '#string#' AS test </cfquery> <cfdump var="#qTest#"> <cfquery datasource="test" name="qTest"> SELECT '#trim(string)#' AS test </cfquery> <cfdump var="#qTest#"> <cfquery datasource="test" name="qTest"> SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="#string#"> AS test </cfquery> <cfdump var="#qTest#"> <cfquery datasource="test" name="qTest"> SELECT <cfqueryparam cfsqltype="cf_sql_varchar" value="#trim(string)#"> AS test </cfquery> <cfdump var="#qTest#"> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
