RE: [INTERFACES] fetchrow reset???

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@magnitudenetwork.net]
>     Sent:    Thursday, February 25, 1999 5:43 PM
>     To:    'pgsql-interfaces@postgresql.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@retep.org.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