Glad to know the 5.0 result. I was just going to test it on 5.0. So, in summary (correct me if wrong):
In MX, but not 5.0, using trim with the value attribute of cfqueryparam adds an additional apostrophe (assuming one existed in the field). So inconsistent behavior in this from 5 to MX; not just a feature of cfqueryparam.? (Also same results on various databases.) Thanks for input Keith ----- Original Message ----- From: "Brad Howerter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 11:10 AM Subject: unexpeted result with cfqueryparam > 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. > - [This E-mail scanned for viruses by declude AntiVirus Software] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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