[EMAIL PROTECTED] wrote: > > I would highly recommend using <cfqueryparam> with MySQL / CFMX. It would > > Reason why? Because escapes all the special characters for you, etc. You > don't need to worry about URLEncoding.
Has something changed with CFMX? All previous versions of CF have automatically escaped the single quote which is the only one that needs to be escaped as far as I know. I've been developing CF apps with MySQL for a couple years now and I've never found the need to use <CFQUERYPARAM> *OR* URLEncodedFormat() in my queries... - Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.