>>CFQUERY automatically assumes they are escaped when it saves, and preservesinglequotes() will escape all your single ticks for you.
Sorry, but it is exactly the other way: CFQUERY automatically escapes single quotes when it saves, and preservesinglequotes() will prevent CFQUERY from escaping if you need the SQL code to be passes as is. Furthermore, something that many forget: 1. preservesinglequotes() is NOT a function, it just does nothing when used outside a CFQUERY tag. 2. preservesinglequotes() will work only if used at the first level on a variable, not inside an expression. ie: trim(preserveSingleQuote(myVar)) is equivalent to trim(myvar) (unless this behaviour changed in CFMX, I never tested since) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242052 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
