does anyone know of an elegant way to group recordset output? For example in ColdFusion you can use the group attribute of the output tag to group the output after retrieving it from the db. I have a query here that is returning a massive amount of records sicne I am using joins on several tables. I need to be able to group the output to make this work.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Group recordset output
- Thread starter thysonj
- Start date
sounds like you need to use SQL's GROUP BY method, or make better use of the joins, if you're just outright joining you're going to end up with excessive data, and all combos, see tarwn's long post in : thread333-934004
or perchance you just might need to use ORDER BY.
or if you're going through many tables, any parent->child relationship can be removed from the join and queried independantly using the parent ID value. it's a seperate loop, but fetching 200k records in one haul (children inclusive) can take a lot of time, versus taking bites of it and chewing on it.
![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!
or perchance you just might need to use ORDER BY.
or if you're going through many tables, any parent->child relationship can be removed from the join and queried independantly using the parent ID value. it's a seperate loop, but fetching 200k records in one haul (children inclusive) can take a lot of time, versus taking bites of it and chewing on it.
DreXaKa - Robert
if all else fails, light it on fire and do the happy dance!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question