Try using CF_TraverseTree by Piet Niederhausen and write the results to a text file so you get rid of the database overhead. CF_TraverseTree is rather slow, but it works fine. I use it to write a DHTML menu, and I think it should work great for you. If you can't get it, I can send it to you off list.
>I'm building a tree like navigation system using just HTML. I want to keep >all the nav links in one table like so: > >Nav 1 > -- Nav 1a > -- Nav 1a1 > -- Nav 1a2 > -- Nav 1a3 > -- Nav 1b > -- Nav 1c >Nav 2 > -- Nav 2a > -- Nav 2b > -- Nav 2b1 > -- Nav 2b2 > -- Nav 2b3 > -- Nav 2c > >My data structure looks like > >navID parentID navText navLink displayOrder >1 null Nav1 nav1.cfm 1 >2 1 Nav1a nav1a.cfm 1 >3 2 Nav1a1 nav1a1.cfm 1 >4 2 nav1a2 nav1a2.cfm 2 >5 2 nav1a3 nav1a3.cfm 3 >6 1 Nav1b nav1b.cfm 2 >7 1 Nav1c nav1c.cfm 3 >... > >Any suggestions on how to accomplish this - preferably with a Stored >Procedure or function? > >Thanks >Duane ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205968 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
