From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Michael Davis <michael(dot)davis(at)prevuenet(dot)com> |
Cc: | "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | RE: [INTERFACES] fetchrow reset??? |
Date: | 1999-02-26 11:04:03 |
Message-ID: | Pine.LNX.4.04.9902261103040.1260-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Fri, 26 Feb 1999, Michael Davis wrote:
> With ODBC and Informix I had to create two different database connections,
> even though you are connecting to the same database.
With JDBC, you have to create a new Statement, which allows you to fetch a
new ResultSet using the same connection.
> -----Original Message-----
> From: Kevin Meldorf [SMTP:kmeldorf(at)magnitudenetwork(dot)net]
> Sent: Thursday, February 25, 1999 5:43 PM
> To: 'pgsql-interfaces(at)postgresql(dot)org'
> Subject: [INTERFACES] fetchrow reset???
>
>
> I have a perl script in which I have 2 while loops that are nested.
> I am comparing the rows of the outer loop against rows of the inner
> loop.
>
> while (@stuff = $foo->fetchrow)
> {
> yadda yadda yadda
>
> while (@otherstuff= $otherfoo->fetchrow)
> {
> yadda yadda yadda
> }
> }
>
> Whenever I reach the end of the inner loop, I can't get it to go to
> the beginning of $otherfoo. I need to be able to reset the object so
> I
> can take the next row from the outerloop and check it against the
> entire
> inner loop structure again. How do I do this????
>
> I have tried reset amongst a bunch of other attempted hacks, but
> nothing
> works!
>
> HELP!
>
>
>
>
--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Mack | 1999-02-26 11:49:03 | [INTERFACES] pgaccess forms |
Previous Message | Michael Davis | 1999-02-26 08:01:25 | Access problems |