Hi Ray, I've done something like this. You can see the result at http://www.theanticool.com/pages/index.cfm. Basically you have to call a custom tag that checks for families for each child. If the child(ren) exists, then you write his info and call the tag again. If theres no children the node closes. If theres multiple children, then you write the next child after the first custom tag call and call it again. If you want to get creative, you can keep track of the depth of the tree like I did. Its pretty heavy on the server(Theres like 30 tags and 30 db calls on this page) so I'd recommend cacheing the page or perhaps writing it dynamically to a static html page. Writing it is quite the adventure- watch out for endless looping- but each page turned out not too big(no bigger than a screen) Also you have to find a way to prevent a malicious user from entering info that calls the parent thereby creating an endless loop.
DRE -----Original Message----- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 4:32 PM 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 ______________________________________________________________________ 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=coldfusiona 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
