Re: Error code

In response to Gustavo Amarilla Santacruz <gusamasan@gmail.com>:

> Thank you, Bill.
> I can not use the numeric error code such as 23505 ( by coding convention );
> I need to do this:

That's fine.  Note, however, that those codes are not numeric.
Also, you'll be better served putting them in constants, to avoid
bugs where the values are accidentally changed.

>
>
> ------------------------ CODE
> -----------------------------------------------------------
>
> include( "PostgresqlErrorList.php" );
>  .
>  .
>  .
>  if( $errorCode == $UNIQUE_VIOLATION )
>  echo( "message" );
>
>
>
>
> ------------------------ CODE
> -----------------------------------------------------------
>
>
> Here, "PostgresqlErrorList.php" is a file included in  PHP libraries. This
> file would can contain code such as:
>
>
>
> <php?
>     $UNIQUE_VIOLATION      = 23505;
>     $DATETIME_FIELD_OVERFLOW  = 22008;
>    .
>    .
>    .
> ?>
>
>
> Exists this file for in Postgresql-PHP library?
>
> On Tue, Sep 22, 2009 at 9:38 AM, Bill Moran <wmoran@potentialtech.com>wrote:
>
> > In response to Gustavo Amarilla Santacruz <gusamasan@gmail.com>:
> >
> > > Thank you, Chris.
> > > Now, I need to do this in PHP:
> > >
> > > -------------------- CODE
> > > ---------------------------------------------------------------
> > >
> > > $errorCode = pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE) ;
> > >
> > > if( $errorCode == UNIQUE_VIOLATION )
> >
> > if ( $errorCode == '23505' )
> >
> > --
> > Bill Moran
> > http://www.potentialtech.com
> > http://people.collaborativefusion.com/~wmoran/
> >
>
>
>
> --
> Gustavo Amarilla
> ISMEB


--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/