Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.9.3/8.9.1) with ESMTP id MAA80735; Wed, 21 Apr 1999 12:08:23 -0400 (EDT) (envelope-from bmccoy@access1.lan2wan.com) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/) id PAA20508; Wed, 21 Apr 1999 15:10:29 -0400 (EDT) Date: Wed, 21 Apr 1999 15:10:28 -0400 (EDT) From: "Brett W. McCoy" To: JT Kirkpatrick cc: "'pgsql-interfaces@hub.org'" , "'pgsql-sql@hub.org'" , "'chugalug@listserv.highertech.net'" Subject: Re: [SQL] perl and postgres. . . In-Reply-To: <01BE8BEC.76C02840.jt-kirkpatrick@mpsllc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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.