>>I see only 10 single quotes in the db. what is the workaround ????
If you have only half of the single quotes in the db, it means that they have not been escaped when transmitted to the query. One out of two is then interpreted as the escape code. DO NOT use preserveSingleQuotes, the purpose of this function is not to... well preserve single quotes, but to prevent CF from escaping them. Can you post the code of your CFQURY? For some reason, the built-in automatic quote escaping has been by passed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4