ColdFusion on knows that an error occurred in that query. The error was returned to CF from the JDBC drivers which in turn received the error from the DB server. As I understand it, ColdFusion reported what it was told to report by a third-party server.
Wil Genovese Sr. Web Application Developer/ Systems Administrator Wil Genovese Consulting [email protected] www.trunkful.com On Jun 25, 2010, at 11:47 AM, Marc Funaro wrote: > > Thanks everyone, > > You were all correct - god help me I was actually focusing on the error CF > gave me, trusting that alone. Go figure. What a rotten thing to do! :) > > A different value was the culprit, and the suggestion below absolutely > applies. > > Thank you all so much -- this is what happens when we get tired, and I always > appreciate the fresh perspective of the community during such times! > >> It's a bit more code, but if you switch to having a cfargument tag for >> each parameter and enforce the type there, you can pass in your >> struct as an argument collection. You'll get a more meaningful error >> that way. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
