> Honestly I'm still a little confused here... I still don't think that > PerserveSingleQuotes() does what you suggest. > > As far as I understand it (which may turn out to be not at > all) CF will automatically escape single quotes in variables placed > inside a cfquery.
I've never found it to be 100% reliable, so to get around this I always use the Replace() and PreserveSingleQuotes() Best to be sure your system will run on your hardware than to risk the occasional error We've had simple Insert's break just because we didn't handle the apostrophies - you can't have a client system breaking just because you've assumed CF will handle it for you In my view, better safe than sorry And since we're usually building our SQL in strings before they're inserted into the database (not always, but usually), then it's easier to do with this way than "poke and hope" Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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
