building a hierarchy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miq - 19 May 2008 22:28 GMT

This is tough to explain so just go with me here...

Here is my tree:

166

|-------------------|---------------------|

103 200
|-----------|-------|
119 125
|--------|------|
101 102

I need to find a way to loop so that 166 can see everything under him,
103 can see everything under him, 125 can see everything under him,
etc...

Going up the tree is easy, each person can only have 1 supervisor, but
going down is starting to throw me off because one supervisor can and
does have many subordinates.

Anybody have a neat or efficient way of doing this?

Reply to this Message

GArlington - 20 May 2008 09:52 GMT

> This is tough to explain so just go with me here...
>
[quoted text clipped - 19 lines]
>
> Anybody have a neat or efficient way of doing this?

You did NOT explain where you want to set up such relationship (I
presume DB), then read about one-to-many relationship and table
join(s): [inner] join in this case...

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / May 2008

building a hierarchy