There are several prbolems with CFMX and DB's, the simplest way is for you to check the following URL for a list of Known Issues,
http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx _updater.html#newissues Jason Lees Development Team Leader National Express Coaches Ltd. -----Original Message----- From: Phillip Cave [mailto:[EMAIL PROTECTED] Sent: 28 February 2003 14:30 To: CF-Talk Subject: Strange characters after MX upgrade Has anyone experienced problems with inserting and updating nText fields after upgrading to CFMX. We have a system that worked fine until the upgrade. Now the system will sometimes (and I mean randomly) insert chr(25) 'end of medium' characters where apostrophes are supposed to be. The queries are quite simple. Insert or update <cfqueryparam cfsqltype="cf_sql_longvarchar" value="#attributes.content#">. Eweb v2.6.0.6 is used for the form control by the way. Before and after examples are below (notice It's and I'm): Before: ------------------------------------ Thank you, Mr. President, and Mr. Vice President, for inviting me here today. It's good to know that you both are working hard and using your leadership to strengthen Social Security. I'm from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. After: ------------------------------------ Thank you, Mr. President, and Mr. Vice President, for inviting me here today. Its good to know that you both are working hard and using your leadership to strengthen Social Security. Im from Oklahoma City, and am currently a Junior at Howard, an historically black university here in Washington, DC. Thanks, Phillip .................................... Phillip Cave ColdFusion Developer Carol/Trevelyan Strategy Group 202.448.5212 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
