Re: Error code

In response to Gustavo Amarilla Santacruz <[email protected]>:

> 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 <[email protected]>wrote:
> 
> > In response to Gustavo Amarilla Santacruz <[email protected]>:
> >
> > > 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/

-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php