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
