I also did not see anything about problems with <cfqueryparam> in this document.
Unfortunately, Bryan's suggestion of placing the value in a simple variable and using that in the cfqueryparam also did not help. I have checked and the error occurs whether I use a cfqueryparam or not. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Bryan Stevenson [mailto:[EMAIL PROTECTED] ....Sent: Tuesday, April 26, 2005 12:39 PM ....To: CF-Talk ....Subject: Re: Strange data mangling .... ....> This document explains the issue and solution: ....> https://www.uwex.edu/oraprod/cfquery.pdf .... ....OK...so at first glance the article explains how CFQUERYPARAM takes ....advantages of bind variables....but I'm not seeing where it explains that ....passed values will be randomly changed into garbage or how to fix it??? .... ....Are you saying that Ian may have previously run a query with a bad value ....and ....now it's somehow cached in the shared pool?? .... ....Am I just being thick?? ;-) .... ....Bryan Stevenson B.Comm. ....VP & Director of E-Commerce Development ....Electric Edge Systems Group Inc. ....phone: 250.480.0642 ....fax: 250.480.1264 ....cell: 250.920.8830 ....e-mail: [EMAIL PROTECTED] ....web: www.electricedgesystems.com/54 .... .... .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:204526 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
