Hi Stan, Thanks. Please send it to me off list
Duane -----Original Message----- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 2:16 PM To: CF-Talk Subject: Database Driven Nav 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205969 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
