Hey Tyler, Don't remove your cfqueryparams. Add a preserveSingleQuotes() call.
<cfqueryparam value="#preserveSingleQuotes(trim(FORM.myVar))#" maxlength="35" cfsqltype="CF_SQL_VARCHAR"> HTH, t ********************************************************************** Tyler M. Fitch Certified Advanced ColdFusion 5 Developer ISITE Design, Inc. 615 SW Broadway Ste. 200 Portland, OR 97205 503.221.9860 ext. 111 http://isitedesign.com ********************************************************************** -----Original Message----- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 6:30 AM To: CF-Talk Subject: Speaking of double quotes>>> Since upgrading to CFMX, <cfqueryparam> is transmuting all my single quotes into double quotes when inserting a string into the db. Is this a bug, or something else? (i.e.: is it my fault?) Right now, it looks like I have to go through and remove all of the <cfqueryparam>'s I've been using over the last several months...not fun-> Tyler Silcox email | [EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
