The DB way is probably better. Mine uses 20 lines of CF code to sort a parent/child relationship table into its proper order. Having the DB do the work rather than CF will probably be faster.
At 06:42 PM 5/23/02, you wrote: >I'll check it out. Alexander's info on the nesting model was fantastic, >though. Once my frontal lobe stops smoking I should be able to build >something really versatile... > >-----Original Message----- >From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] >Sent: Thursday, May 23, 2002 3:28 PM >To: CF-Talk >Subject: Re: Build a tree of nodes/subnodes > > >something like this result? >www.houseoffusion.com/testbed/cfom >If so, I can release the code out to you early. I'm using it in an article >for Nathan Stanford. It's really fast and tight, but a bit strange to look >at. :) > >At 05:34 PM 5/23/02, you wrote: >>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 >> >> > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
