Thanks for the response. I guess I should have mentioned that it's MySQL.
I'm thinking that I could do something like... itemID ItemTitle ItemURL ItemParentID And parent ID would just point to another record in the same table if the item was indeed a sub item of another item. That items 'parent' could then also point to another item as its parent, etc... And maybe just a 0 for parentID when the item is 'top level'. I've used this before but I've always known exactly how deep the nests would go which in turn let me know exactly how many nested loops I would need to build everything ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Friday, October 21, 2005 5:19 PM To: CF-Talk Subject: Re: SOT: data structure for unlimited nested items 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221874 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
