On the whole, posting the code rather than describing the code is more helpful in these situations.
The before and after versions might be helpful too. Did anything other than the usage of <cfqueryparam> change? -- Adam On 20 May 2014 20:01, daniel kessler <[email protected]> wrote: > > I may be outside of the CF bounds here, but this problem wasn't showing up > until we added CFQueryParams. We are in CF9. > > I am adding CFQueryparams to an INSERT. The item that I am sending over > to the oracle 11g db is empty text. The CFQueryParam is varchar because I > am sending it over as text. > From there, it is encrypted and a Cast_to_RAW is done on it to be put in a > RAW field. This is failing with an "invalid hex number" error. > > Overall, I don't receive the error consistently. However, I haven't been > able to reproduce this without the CFQueryparam. > > Any thoughts on this? Or any clarification questions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
