Thank you
At 09:43 AM 2/15/2002 +1000, you wrote:
>Try secretagents.com and look for the nested hierarchy tute for SQL.
>It's what I use and its incredibly powerful (e.g. one-query hierarcy
>display, tree walks, etc)
>
>Darryl
>
>-----Original Message-----
>From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
>Sent: Friday, 15 February 2002 9:32 AM
>To: CF-Talk
>Subject: Recursive help!!!!
>
>
>My mind just isn't working, I need help with some logic here if any of
>you
>would....
>I have a table that houses all employees and each is unique by employee
>number, there is a hierarchy of management by storing each employee's
>supervisors employee number in the record. For example my bosses emp
>num
>is 24, I am emp num 44. My record looks like this.
>empnum fname lname supvnum
>44 ray Bujarski 24
>
>
>I need to create a structure that has a hierarchy list of employees, I
>have people reporting to me so, my supervisor should have all my
>employees
>listed in his list of employees along with myself.
>Can anyone help me with this logic....I am at nerves end.
>Thank you!
>Ray
>
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
