From: | Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)com> |
---|---|
To: | Bill Moran <wmoran(at)potentialtech(dot)com> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Error code |
Date: | 2009-09-22 14:20:11 |
Message-ID: | e4ea2d810909220720i38860764sd5366878325cd4f2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Thank you, Bill.
I can not use the numeric error code such as 23505 ( by coding convention );
I need to do this:
------------------------ 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(at)potentialtech(dot)com>wrote:
> In response to Gustavo Amarilla Santacruz <gusamasan(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2009-09-22 15:08:35 | Re: Error code |
Previous Message | Bill Moran | 2009-09-22 13:38:15 | Re: Error code |