> > Why? It will almost certainly be a much better solution > > than anything else you're considering. > > Dave - Not sure it's better than 'anything else.' Why stick > with a query that'd need constant grouping when what he's got > in the DB is a set representing a hierarchical data structure? > > Instead of returning a query that'd need grouping each time > you use it, you could build up a struct once (by grouping) > and then logically navigate / manipulate it on an ad-hoc basis ...
I didn't say "anything else", but rather "anything else [he] was considering". That said, you could certainly store the grouped query results however you like; you could even store the generated page output. None of that is inconsistent with my suggestion, which simply involved having one query instead of a series of queries. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4