Re: [SQL] perl and postgres. . .

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.