> Not to argue with Ben, but I don't think that > PreserveSingleQuotes() is > the answer... That function prevents CF from automatically esacping > single quotes (in this case you WANT CF to escape them for you).
I think you're confused a little with what CF terms as "escaping" the single quotes It converts all single quote types to their real single quote versions for SQL (used in WHERE and such), normally it won't always put the apostrophies in for the INSERT and UPDATE, it's almost a hit-and-miss thing This is why my wife suggested using Replace() combines with PreserveSingleQuotes() as it's the only guaranteed way of getting it working 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
