> What still doesn't seem to make sense is that using the trim() in the > cfqueryparam value does add an additional apostrophe, but not using trim() > doesn't.
Hmmm....could've sworn I tested this before but...I just tested <cfqueryparam cfsqltype="cf_sql_varchar" value="#showLabel#" /> and, sure enough, foo becomes abc's again...just what we want. So...I guess as long as we leave well enough alone (that is, don't use *any* functions with CFQUERYPARAM), CFQUERYPARAM gets the database to do all the work, right? ~Dina ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4