RE: Looping through recordset twice

2001-11-02 Thread Don Seiler
I guess I'm not that concerned with that level of detail. there are a million different ways to do that part. It was just the part of finding the groups that I needed help with. Thanks though. Don. On Fri, 2 Nov 2001, Wilson, Doug wrote: > > > From: Don Seiler [mailto:[EMAIL PROTECTED]] > >

Re: Looping through recordset twice

2001-11-02 Thread David Marshall
hrough the recordset though. > > > > > > > >-- > > > >Don Seiler [EMAIL PROTECTED] > > > >Database Administrator / Sr Software Engineer > > > >NSightTel Billing LLCPhone: 920.617.7501 > > >

Re: Looping through recordset twice

2001-11-02 Thread Etienne Marcotte
0 Mid Valley DriveFax:920.617.7493 > > >De Pere, WI 54115 Cell: 920.606.3240 > > >Pager: [EMAIL PROTECTED] / 920.613.2000 > > > > > > > > >On Thu, 1 Nov 2001, Marcelo Guelfi wrote: > > > > > > > > > > > Are you

Re: Looping through recordset twice

2001-11-02 Thread Don Seiler
t; > > > > >On Thu, 1 Nov 2001, Marcelo Guelfi wrote: > > > > > > > > Are you sure that you can't use the GROUP BY clause? > > > > > > Saludos, > > > Marcelo. > > > > > > > > > > > >

Re: Looping through recordset twice

2001-11-02 Thread Don Seiler
GENIUS! That did the trick. Thanks much, Don. On Fri, 2 Nov 2001, Ronald J Kimball wrote: > On Fri, Nov 02, 2001 at 08:42:42AM -0600, Don Seiler wrote: > > Perhaps I wasn't supposed to take it so literally, and my hash handling > > skillz aren't quite what they should be. > > > > When I do thi

Re: Looping through recordset twice

2001-11-02 Thread Ronald J Kimball
On Fri, Nov 02, 2001 at 08:42:42AM -0600, Don Seiler wrote: > Perhaps I wasn't supposed to take it so literally, and my hash handling > skillz aren't quite what they should be. > > When I do this: > > while (my $hashref = $csr->fetchrow_hashref()) > { > print "Adding record from group " . $has

Re: Looping through recordset twice

2001-11-02 Thread Don Seiler
TED] / 920.613.2000 > > > > > >On Thu, 1 Nov 2001, Marcelo Guelfi wrote: > > > > > > > > Are you sure that you can't use the GROUP BY clause? > > > > > > Saludos, > > > Marcelo. > > > > > > &

RE: Looping through recordset twice

2001-11-01 Thread Wilson, Doug
> From: Don Seiler [mailto:[EMAIL PROTECTED]] > > Basically, when I get to a new group number. The record set > is ordered by > group number, so all records in a group are together. As I'm looping > through records in a group, I do some evaluation and add values to > variables. When I get to

Re: Looping through recordset twice

2001-11-01 Thread Don Seiler
> > > > Saludos, > > > Marcelo. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > "Don Seiler&q

Re: Looping through recordset twice

2001-11-01 Thread David Marshall
> > > > > > > > > > > > > > > > > > > "Don Seiler" > > <[EMAIL PROTECTED]> > > llcom.com> cc: Marcelo > Guelfi/Uruguay/Contr/IBM@IBMUY

Re: Looping through recordset twice

2001-11-01 Thread Don Seiler
"Don Seiler" > <[EMAIL PROTECTED]> > llcom.com> cc: Marcelo >Guelfi/Uruguay/Contr/IBM@IBMUY, <[EMAIL PROTECTED]> > Subject: Re: Looping through

Re: Looping through recordset twice

2001-11-01 Thread Marcelo Guelfi
Don Seiler" llcom.com> cc: Marcelo Guelfi/Uruguay/Contr/IBM@IBMUY, <[EMAIL PROTECTED]> Subject: Re: Looping

Re: Looping through recordset twice

2001-11-01 Thread Don Seiler
Basically, when I get to a new group number. The record set is ordered by group number, so all records in a group are together. As I'm looping through records in a group, I do some evaluation and add values to variables. When I get to a new group number, I look at the values. If they meet my c

Re: Looping through recordset twice

2001-11-01 Thread Michael Peppler
Don Seiler writes: > Actually the nature of the problem is what stopped me from doing this. > > I won't know which records I want until I look at the group of them. > > Example: I have a table of records. There is a "groupnum" column. Many > records have the same "groupnum", i.e. they a

Re: Looping through recordset twice

2001-11-01 Thread Michael Peppler
Don Seiler writes: > I was considering this, but just thought it would be easier to just set > the flag in an aux structure and loop through my original recordset again, > checking the flag each time. > > Anyone know if there is a definitive yes/no on this? There are various issues to consi

Re: Looping through recordset twice

2001-11-01 Thread Don Seiler
arcelo. > > > > > > > > > > > "Don Seiler" > llcom.com> cc: > Subject: Looping through recordset twice >

RE: Looping through recordset twice

2001-11-01 Thread Kong, Alan
ubject: Re: Looping through recordset twice I don't think so. Why don't you put the selected records in an auxiliary structure (hash, array) and then go through that structure? Saludos, Marcelo. "Don Seiler"

Re: Looping through recordset twice

2001-11-01 Thread Don Seiler
r" > llcom.com> cc: > Subject: Looping through recordset twice > 01/11/2001 > 15:34 > Please respond > to "Don >

Re: Looping through recordset twice

2001-11-01 Thread Marcelo Guelfi
Marcelo. "Don Seiler" cc: Subject:

Looping through recordset twice

2001-11-01 Thread Don Seiler
Is there a way to back through a recordset after I've already gone through it? I want to go through the recordset, determining if certain groups of records meet my criteria. Then I want to go through again and print the groups that qualify. Since I have to deal with groups of records, I couldn'