Interspersed.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Reuss, Bob" <[EMAIL PROTECTED]>
To: "'Michael A. Chase'" <[EMAIL PROTECTED]>
Sent: Thursday, April 19, 2001 1:15 PM
Subject: RE: Count on rows returned
> I am running a select statement with multiple fields being pulled back and
> mulitple rows. I need to have a count of the rows returned before
actually
> walking through the returned rows. I tried running through the results,
> counting to get the rows and then running through the results again,
> however, I believe I need to reset the results back to the first row
before
> looping through to display.
Why?
> Is there a way to set the resultset back to the
> first row? This would solve my problem.
No. You could collect your information first then output it in a separate
loop.
Please send further questions to the list.
>
> > -----Original Message-----
> > From: Michael A. Chase [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, April 19, 2001 2:59 PM
> > To: Reuss, Bob; [EMAIL PROTECTED]
> > Subject: Re: Count on rows returned
> >
> > Count them as you fetch them.
> > --
> > Mac :})
> > ** I normally forward private database questions to the DBI mail lists.
**
> > Give a hobbit a fish and he'll eat fish for a day.
> > Give a hobbit a ring and he'll eat fish for an age.
> > ----- Original Message -----
> > From: "Reuss, Bob" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, April 19, 2001 12:25 PM
> > Subject: Count on rows returned
> >
> >
> > > I was wondering, what would be the best way to get a count of the
number
> > of
> > > rows returned from a select statement using DBI::ODBC?
