This document explains the issue and solution: https://www.uwex.edu/oraprod/cfquery.pdf
Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 2:06 PM To: CF-Talk Subject: Strange data mangling Can any one see why the following line of code would mangle a value such as "000002" into "3L�002"? TRAN_CODE = <cfqueryparam value="#ucase(arguments.dataStruct.Tran_Code)#" cfsqltype="cf_sql_varchar">, I've tested the value just before this query and at that point it is correct and intact. But once the query runs a seemingly random 3 char value is pre-pended to the value that is supposed to be inserted. CF 6.1 Oracle 8i Oracle Thin Client If any of those matter. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
