Joe Celko approaches this issue in his books. http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202
I have used one of his hierachies after a friend turned me on to his methodology. I used it to manage a staff hierarchy of employees to managers. After the table is created into an aggregate hierarchy, the search time and features are fantastic. I can search through parent and child relationships with very simple queries. I believe Joe has a google group and has some code or discusses this idea there as well. It is an intermediate to advanced topic in DB architecture, but a few days research and your are done. Teddy On 9/27/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>If I had more free time I'd finish it > > You'll need quite a lot ;-) > I started my project about 25 years ago,... under CP/M ;-) > But believe me, it is fun ;-) > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
