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:205966
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
