Hi All, I need some advices (and sample codes if possible) about how to implement a parent child style database. I read the articles at sql team
http://www.sqlteam.com/item.asp?ItemID=8866 Anyone has a better and/or easier solution for nested trees ? By the way I'm going to use it to calculate sales totals of affiliates where an affiliate can have their own sub affiliates, and a sub affiliate can have its own ones too etc... Any advise is greatly appreciated, Mahmut Basaran ~~oO Measure Twice Cut Once Oo~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
