http://www.calacademy.org/research/informatics/taf/proceedings/ballew/sld035.htm
this is what i was thinking of. starting somewhere around the beginning walks you through how to build a nested set. The slide referenced above shows you how to generate a breadcrumb list for a given page. On 10/21/05, Anthony Prato <[EMAIL PROTECTED]> wrote: > If you use oracle the whole id,parentid setup can work ok. If it gets > slow you can just generate an xml file for the site to use for > menus/sitemap each time an update is done in the admin panel, or if > it's really slow, leave it to a manual button push. Personally what > I've used in the past is a method of storing a nested structure in a > relational database called Nested Sets. Its very cool once you get the > hang of it. Don't have my links with me but try googling it. Pretty > sure it's been brought up here before too. There used to be a great > overview slideshow out there but i can't find it at the moment > > Anthony > > On 10/21/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > I've been racking my brain trying to come up with a feasible solution to a > > dynamic site map for a current project. Normally it would be a no-brainer > > but this time, the site is HUGE and has nested section after section after > > section... > > > > Once the client receives the final application, they will be adding even > > more sections (and undoubtedly subsections). > > > > I'd like to come up with a way to build the site map dynamically so I (and > > eventually they) can just add any new section's title and URL to the > > database. > > > > Without knowing exactly how deep the nests will go, it's proving to be > > tough. > > > > I'm curious to know if anyone else has done something similar with a site > > map or a menu or something that dynamically gave the ability to add > > unlimited nested items and if so what your database structure looked like. > > > > Thanks for any ideas. > > > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > > Bobby Hartsfield > > http://acoderslife.com > > > > -- > > No virus found in this outgoing message. > > Checked by AVG Anti-Virus. > > Version: 7.0.344 / Virus Database: 267.12.4/143 - Release Date: 10/19/2005 > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:221873 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
