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 are in the same group. I'm only interested in selecting the group as a whole. I will only know if I want this group based on examining all of the records for that group. I suppose I could put each record for that group into an array, then perform my calculation and print the array if I want to and then empty the array in either case. *shrug* Don. On Thu, 1 Nov 2001, Marcelo Guelfi wrote: > > 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" > <Don.Seiler@Ce To: [EMAIL PROTECTED] > llcom.com> cc: > Subject: Looping through recordset twice > 01/11/2001 > 15:34 > Please respond > to "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't see how to just do this in the WHERE clause of the originating > SQL. > > Thoughts? > Don. > > > > > > > >
