Although xml is the proper way to display data, I need to calculate data. I'm still working on it. If I come up with anything (hopefully) I'm going to post it to the forums.
Thanks everyone, Mahmut ----- Original Message ----- From: "Rob Rohan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 11:08 AM Subject: RE: parent - child relations > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4