Sorry for the blatant plugs, but my cms does pretty much exactly what you're talking about for US$350. Doesn't do 2 menus at once but it could if you wanted to tinker with it. Also have you looked at the freebie HierMenus and Milonic menu builders in the devex?
You mentioned you need to generate these on the fly. If you mean doing it on every page visit then you'll find that's too big of a hit on your db as your page count climbs, even with something like a nested set to ease stuff up. Pre-building on the admin side and storing the output - either in a db record or writing to a static .js file - lightens the load to almost nothing. Both of the free tags I posted do that. -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- -----Original Message----- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 5:44 AM To: CF-Talk Subject: Re: Nested Record Sets and Menus This is for a school district's adult ed site. They want the HeirMenu for the primary menu, plus a side nav for their section 508 compliance. They want the ability to edit the menu and it's options at will, since they will have an editor for adding additional pages to the site. I need to create the HM_Array.js on the fly (through <script language="Javascript" type="text/javascript" src="HM_Array.cfm"></script>) from the db, as well as the side nav with the same options (depending on what section a user is in). I am using CFMX along with the design pattern layed out at http://www.benorama.com. The beginning basic layout (without the working menus) can be seen at http://polytech2.dmvwebhosting.com. Cutter Matthew Walker wrote: >Implementing the nested set model is a big task. If you're running out of >time, I would recommend giving up. Due to its complexity, this is something >that should be addressed at the very earliest stages of development IMO. >What do you actually need to do? Create a tree and move nodes around it? >Then generate menus based on that? Is the ability to edit the tree once made >important? Could you set the system up now and add editing later? What's the >situation? > >----- Original Message ----- >From: "Cutter (CF_Talk)" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, February 04, 2003 6:27 PM >Subject: Re: Nested Record Sets and Menus > > > > >>Unfortunately this is not an option. I have little to no control over >>the SQL 7 server, and our sysad will not load any type of XML plugin. >>Any other options? Anyone? The time crunch is breakin' my back here... >> >>Cutter >> >>John Quarto-vonTivadar wrote: >> >> >> >>>the best way to think about Nested Record Sets (a la Celko) is to just >>> >>> >think > > >>>of them as XML. If you can understand it that way, then you the human >>> >>> >are > > >>>all "set" (pardon the pun). The various code snippets and stored procs >>> >>> >that > > >>>you see floating around are just ways of translating that to/from a >>>relational database. In fact, with CFMX's decent XML handling, it might >>> >>> >be > > >>>easier for you just to work in terms of XML and let the RDBMS' native >>> >>> >code > > >>>for translating XML into records do the nasty work for you (I think SQL >>>Server either has XML capability built in or available as a plug-in or >>>something) >>> >>>----- Original Message ----- >>>From: "Cutter (CF_Talk)" <[EMAIL PROTECTED]> >>>To: "CF-Talk" <[EMAIL PROTECTED]> >>>Sent: Monday, February 03, 2003 10:08 AM >>>Subject: Nested Record Sets and Menus >>> >>> >>> >>> >>> >>> >>>>Could somebody please help me... >>>> >>>>SecretAgents.com used to have paid tutorials to show you how to do >>>>things. They had a set of tutorials on how to setup/access/update/use >>>>nested record sets on MSSQL to create heirmenus. So, after reading the >>>>first three, I put in the PO request to my company to get access to the >>>>final tutorials (the ones with the real juice). While my finance folks >>>>took there time in processing the request (about a week) all tutorials >>>>dissappeared from the site. The site manager told me that they would be >>>>back, but they have not yet (this has been 3 weeks and my finance people >>>>have file thirteened my request now for lack of access). >>>> >>>>Some folks on this list have given me links to some extensive, >>>>exhaustive and complicated articles that I am still trying to decipher. >>>>Has anyone here done this already? Can someone help me figure this out? >>>>Or provide some sample info? I've got a client who's getting way >>>>restless now, and this is the last piece of info I need to get them >>>>straight. Any help would be greatly appreciated. >>>> >>>>Cutter >>>> >>>> >>>> >>>> >>>> >>>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

