Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] fetchrow reset???

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 (view raw or flat)
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


In response to

pgsql-interfaces by date

Next:From: Thomas MackDate: 1999-02-26 11:49:03
Subject: [INTERFACES] pgaccess forms
Previous:From: Michael DavisDate: 1999-02-26 08:01:25
Subject: Access problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group