On Wed, 30 May 2001 08:07:11 -0400, newsreader@mediaone.net wrote:
> DBD::Pg 1.00 won't allow me to use the following
> the code anymore
>
> ----------
> $s=$dbh->prepare('select * from table');
> $s->execute or die $dbh->errstr;
> while(my @a=$s->fetchrow_array())
> {
> ... do something
> }
> while(my @a=$s->fetchrow_array())
> {
> .. do something else
> }
> -----------
>
> It was fine before with 0.9?
>
> Now I need another execute statement before
> the second while statement.
That's because previous versions of DBD::Pg had a bug which didn't remove the Active attribute from statement handles
whichall rows had been fetched from.
The new behaviour is mre correct.
--
Peter Haworth pmh@edison.ioppublishing.com
"I'm just a mere programmer"
-- James Counihan