A TCL catch has to be put around all ns_db calls. If an error is thrown, THEN you can try doing ns_db calls to get info. Jim > > After looking into this a bit more, the Ns_MySQL_DML function returns > NS_ERROR as per spec on a failed insert, but it seems like returning > NS_ERROR is a complete show-stopper. > > As far as I can tell, returning NS_ERROR halts execution of any remaining > TCL in a procedure. Does anyone know if this is the case? > > >From: Dossy <[EMAIL PROTECTED]> > >To: Tony Wells <[EMAIL PROTECTED]> > >Subject: Re: [AOLSERVER] Trapping exceptions with Panoptic MySQL driver > >Date: Fri, 30 Mar 2001 16:41:03 -0500 > > > >Thanks for bringing this to my attention. > > > >I'll look at implementing it (no, it's not currently implemented). > > > >Thanks again. I'll announce when it's ready. Perhaps tonight. > > > >- Dossy > > > > > >On 2001.03.30, Tony Wells <[EMAIL PROTECTED]> wrote: > > > Hi again, > > > > > > I'm having a problem getting exception error codes on database inserts. > >I > > > want to be able to tell if an insert happened successfully, but it seems > > > 'ns_db exception' doesn't do anything. > > > > > > Is there something I'm missing, or is that functionality missing from > >the > > > driver? > > > > > > BTW, I use 'ns_db dml' to do the insert. > > > > > > Thanks to everyone for their help, > > > Tony Wells > > > _________________________________________________________________ > > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > >-- > >Dossy Shiobara mail: [EMAIL PROTECTED] > >Panoptic Computer Network web: http://www.panoptic.com/ > > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com >
