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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
