Using only cfquery? No, cfcatch.nativeErrorCode is part of the cfcatch scope.
But it's easy to wrap a ctry/catch around the query, and then you'll have cfcatch.nativeErrorCode and cfcatch.sqlstate. We get them when triggers or stored procedures fail (CF 4.5 SP2, Solaris, Oracle 9i) Chris Norloff ---------- Original Message ---------------------------------- from: jon hall <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Fri, 13 Dec 2002 16:54:37 -0500 > Is there any way in CF5 to get this information using only cfquery? > In particular I am having a problem where a trigger is returning an > error, but not throwing an error. > >-- > jon > mailto:[EMAIL PROTECTED] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
