I was mistaken. I accidentally tested the code on CF50, where it does work okay. On CFMX, updating an Oracle database, it adds an apostrophe as you say. And it only does it when trim() is used.
>Brad and Kevin > >Went back and tired not using the HTMLEditFormat--no difference. Also tried >bypassing the CFC and argumentcollection, doing a direct update. No >difference. >Seems to be something only with the cfqueryparam and trim. > >Again, without the trim, works as expected. With a trim, get the additional >'. >Should have said that using MX. >Am using Access as database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
