From: | James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us> |
---|---|
To: | "George P(dot) Esperanza" <george(at)calamba(dot)laguna(dot)net> |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] Status Checking |
Date: | 1999-07-12 03:41:15 |
Message-ID: | 378963DA.768C173E@lee.k12.nc.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> Hi!
>
> Sorry for posting this simple question....
>
> I'm just new to postgres and i'm using PERL interface to access my
> databases. I just want to know how can i check or get the status if my
> query command has no errors.
>
> $dbh = Pg::connectdb("dbname=MMS");
>
> How do i check if there's no error connecting to my database MMS?
>
> $sth = $dbh->exec("select syskey from syskey where syskey =
> '$syskey'");
> $sth = $dbh->exec("insert into syskey values('$syskey', '$value',
> '$desc')");
> $sth = $dbh->exec("delete from syskey where val='test'");
>
> How to i check if my select, insert and delete statement has no error?
>
All of these questions can be answered by typing:
man Pg
and reading the text.
Cheers...james
>
> Thanks...
>
> George
>
> ---------------------------------------------------------------------
> | George P. Esperanza e-mail : george(at)laguna(dot)net |
> | Laguna Internet phone : (049) 545-2358 |
> | 6 East Arcade Calamba Trade Center |
> | Calamba, Laguna |
> ---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 1999-07-12 07:41:01 | RE: [INTERFACES] jdbc redhat 6.0 NoClassDefFoundError |
Previous Message | Philippe Chaintreuil | 1999-07-10 11:01:21 | Re: [INTERFACES] crypt error |