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:358671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm