There's an article ("Recursion 101") on Defusion.com that may help:
http://www.defusion.com/articles/index.cfm?ArticleID=63
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603 Fax 210-490-4692
> -----Original Message-----
> From: MainWizAccount [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 04, 2001 5:42 PM
> To: CF-Talk
> Subject: Query with nested hierarchy
>
>
> I need some help in developing either a query or a stored procedure that
> will pull out nested data for an organizational chart. Say I have the
> following database
<snip>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
