It seems though, if you are need that much nested data there is probably a better solution to the problem then this type of tree model (i.e. using master - detail tables) that a database might be more optimized for (or perhaps xml might be a solution).
Rob -----Original Message----- From: webguy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 10:54 AM To: CF-Talk Subject: RE: parent - child relations The problems with that method is path enumeratation etc. It's easy if you have an id and just want the category under x, But what if you want the nodes from root to a deeply nested node. It turns out to be a very expensive query... Thats why the Nested Tree Model is useful (see my last mail) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4