The end result I am trying for is a structure (associative array) suvPhNum = empList where empList = all direct reports and all of each direct reports reports etc...
At 03:31 PM 2/14/2002 -0800, you wrote: >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
