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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
