| From: | jeff <jeffers(at)hctc(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)hub(dot)org |
| Subject: | ack... problems with Pg, please advise. |
| Date: | 1999-02-09 00:45:19 |
| Message-ID: | 36BF851F.4CA449BD@hctc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
hello, i just installed postgreSQL and it works great, i imported my db
and it works great with the psql interface, and i even can access it
from the shell with a perl script. but when i cut and paste the code
into a cgi, it returns nulls (albiet the appropriate number of nulls).
here is my code, what am i doing wrong? thanks.
<begin code snippet>
unless ($a) {$a="Metallica";}
$conn = Pg::connectdb("dbname=tempest");
(PGRES_CONNECTION_OK eq $conn->status )
and print "Pg::connectdb ........... ok<br>"
or die "Pg::connectdb ........... not ok: ", $conn->errorMessage;
# this part works, as the "ok" message is shown on the page...
$result = $conn->exec("SELECT title from cds where artist='$a'");
while ( @row=$result->fetchrow ) {
print "@row";
print "<br>\n";
}
<end code snippet>
it returns the correct number of <br>s, but prints nothing, @rows
appear to be null. any ideas?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Williams | 1999-02-09 01:04:04 | Re: [INTERFACES] Rapid web based apps? |
| Previous Message | D'Arcy J.M. Cain | 1999-02-08 21:33:14 | Re: [INTERFACES] Rapid web based apps? |