i think that you can do this with one table, and a couple columns. 1. id (int or uuid, doesnt matter) 2. menuItemLabel (varchar of some length) 3. parentID (default 0 or null)
then to get the top level, get where parentID = 0 or null then for each record, run a query of query based on the id you have for the top level one you are on in your iteration, and just go from there. i think you can nest as many as you want to make sure it goes and gets all nested sub categories, but as long as you know the limit of those, you can make this work, with one trip to the database, and then just some qofq work, and cfml layout with html intertwixted! :) hth tony On 2/16/06, Donna French <[EMAIL PROTECTED]> wrote: > Okay, so I've been reading several books on usability and finally decided to > break down and add a breadcrumb trail to my site. For my top level I'll need > to link to one of 10 pages depending on the category so the only option I see > here is either multiple CFIF's or CFCASE to grab the correct page according > to categoryID. But I wanted to run it past you all before I write the code to > see if I'm missing an obvious easier solution. For those of you wondering why > I have 10 different pages for the top level categories it's for SEO reasons > and has proven very beneficial. TIA, Donna > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:197289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54