Hate to say it, but... The nested sets model is exactly what you're looking for http://www.intelligententerprise.com/001020/celko.shtml http://www.secretagents.com/index.cfm?fuseaction=viewlets.freeviewlet&viewle t_id=45
----- Original Message ----- From: "Ian Lurie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, May 24, 2002 9:34 AM Subject: Build a tree of nodes/subnodes > I'm sure someone out there has already figured this one out: I'm trying to > build a tree of nodes and subnodes. Branches of the tree may be of varying > depths, and the entire tree may vary in size, too. > > I'd like to be able to access the tree from CF, so that I can pull all nodes > and subnodes from the node 3 branch, or the node 10 sub-branch, or whatever. > > 'Faking' a recursive query won't work because of the varying depth. And my > little brain can't conceive of a genuine recursive query that'll do the > trick. > > Anyone ever dealt with this? > > Ian > > Portent Interactive > Helping clients build customer relationships on the web since 1995 > Consulting, design, development, measurement > http://www.portentinteractive.com > Talk with us: http://projects.portentinteractive.com > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
