Re: Std.'ized error codes

2004-04-02 Thread Jonathan Leffler
Tim Bunce wrote: Note that all I was after as a fairly *short* list of the specific SQLSTATE codes that correspond to errors that applications *often* want to explicitly check for. Duplicate key being an obvious example. SQL-99 (ISO/IED 9075-2:1999) defines standardized SQLSTATE values in Table

Re: Std.'ized error codes

2004-04-02 Thread Tim Bunce
On Fri, Apr 02, 2004 at 12:16:06AM -0800, Jonathan Leffler wrote: Tim Bunce wrote: Yes. There are two things I want to do: 1. Specify a fairly short list of the specific SQLSTATE values that I'd like drivers to support as a minimum. I'd prefer to have it called something else -- I'd

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-04-01 Thread Tim Bunce
On Wed, Mar 31, 2004 at 08:23:02PM -0800, Michael Peppler wrote: On Wed, 2004-03-31 at 17:56, Jonathan Leffler wrote: Dean Arnold wrote: A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records, but I kind of dropped

Re: Std.'ized error codes

2004-04-01 Thread Steffen Goeldner
} = $hash_ref_or_code_ref; The DBI would then use that to set state() if it was left undef. I like the idea of std.'ized error codes. However, there isn't much I can do for DBD::ADO: Source : Microsoft JET Database Engine Description : The changes you requested to the table were

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-03-31 Thread Dean Arnold
A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records, but I kind of dropped the ball - changing jobs and all didn't leave me enough time to persue that standardization with members of this list. And since now I don't

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-03-31 Thread Jonathan Leffler
Dean Arnold wrote: A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records, but I kind of dropped the ball - changing jobs and all didn't leave me enough time to persue that standardization with members of this list. And

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-03-31 Thread Dean Arnold
Dean Arnold wrote: A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records, but I kind of dropped the ball - changing jobs and all didn't leave me enough time to persue that standardization with members of this list.

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-03-31 Thread Michael Peppler
On Wed, 2004-03-31 at 17:56, Jonathan Leffler wrote: Dean Arnold wrote: A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records, but I kind of dropped the ball - changing jobs and all didn't leave me enough time to

Re: Std.'ized error codes (was insert into two table and check table perl DBI)

2004-03-31 Thread Jonathan Leffler
Dean Arnold wrote: Jonathan Leffler wrote: Dean Arnold wrote: Hardy Merrill wrote: A few months ago we had discussed on this list _standardizing_ error handling for things like trying to insert duplicate records [...] Basically all it involved was putting together a list of common error