Hey Ian... Question... and I think I can guess at the answer but I'd rather know your thoughts for sure...
Why are you using ucase() on a numeric value? I'm assuming because it's not always going to be numeric, right? Next question... is the value in this variable being set by a process that insures it's a string, or could something like this be happening: <cfset myVar = 000002> <-- note: no quotes. Numerical, not string literal <cfset testVar = ucase(myvar)> It doesn't do anything wrong in a test page, but it might be affecting the cfqueryparam tag... so give this a try: value="#ucase(toString(arguments.dataStruct.Tran_Code))#" Also, do you have your cfargument tag's type="" attribute set explicity to type="struct" because that may be affecting things. Give'm a try, let us know... Laterz, J On 4/26/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > 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 -- --------------- ------------------------------------- Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204571 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
