pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedperl and postgres. . .
2+ messages / 2 participants
[nested] [flat]
* perl and postgres. . .
@ 1999-04-21 15:45 JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
1999-04-21 19:10 ` Re: [SQL] perl and postgres. . . Brett W. McCoy <bmccoy@lan2wan.com>
0 siblings, 1 reply; 2+ messages in thread
From: JT Kirkpatrick @ 1999-04-21 15:45 UTC (permalink / raw)
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>; 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'chugalug@listserv.highertech.net' <chugalug@listserv.highertech.net>
I'm trying in perl to get a maximum value from a field in a postgres table:
$query="select max(userseq) from dataentry;";
$result=$conn->exec("$query");
and then capture that value in a scalar variable:
$userseq=($result);
but it's not working. The field userseq is int4 if that matters to you.
if I can capture that value in a variable then I can use it in an update
query for that particular record. Can anyone enlighten me??
jt
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] perl and postgres. . .
1999-04-21 15:45 perl and postgres. . . JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
@ 1999-04-21 19:10 ` Brett W. McCoy <bmccoy@lan2wan.com>
0 siblings, 0 replies; 2+ messages in thread
From: Brett W. McCoy @ 1999-04-21 19:10 UTC (permalink / raw)
To: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>; 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'chugalug@listserv.highertech.net' <chugalug@listserv.highertech.net>
On Wed, 21 Apr 1999, JT Kirkpatrick wrote:
> I'm trying in perl to get a maximum value from a field in a postgres table:
> $query="select max(userseq) from dataentry;";
> $result=$conn->exec("$query");
>
> and then capture that value in a scalar variable:
> $userseq=($result);
>
> but it's not working. The field userseq is int4 if that matters to you.
> if I can capture that value in a variable then I can use it in an update
> query for that particular record. Can anyone enlighten me??
You can't get row information from a query that way. You need to use
$result->fetchrow to get the actual data out of your query (it returns
Null if there are no more rows to fetch from). You could do something like:
@q_row = $result->fetchrow;
$userseq = $q_row[0];
To get that information.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Self Test for Paranoia:
You know you have it when you can't think of anything that's
your own fault.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-04-21 19:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-21 15:45 perl and postgres. . . JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
1999-04-21 19:10 ` Brett W. McCoy <bmccoy@lan2wan.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox