in reply to Multiple Results Sets with DBI
My guess is that you are issuing something like this:do { while($data = $sth->fetchrow_hashref()) { .... process $data .... } } while($sth->{syb_more_results});
In that case the first time through the do/while loop you'll get the output from the COUNT(), and the second time you'll get each of the rows from your SELECT.select count(*) from table where ... select ... from table where ...
Michael
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Multiple Results Sets with DBI
by Anonymous Monk on Aug 21, 2003 at 20:16 UTC | |
by mpeppler (Vicar) on Aug 21, 2003 at 20:20 UTC | |
by Anonymous Monk on Aug 21, 2003 at 20:27 UTC | |
by Anonymous Monk on Aug 21, 2003 at 20:29 UTC |