Have you seen David Medinets' proof of concept procs? (www.mtolive.com/ntm)
You should be able to create an insert proc, then write a CF script to build your tree using the old model and loop over it inserting as you go. May be a little work, but should do the trick. The long run payoff will be substantial. -Cameron ----------------- Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -----Original Message----- > From: Thomas Eppler [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 29, 2002 3:46 PM > To: SQL > Subject: AW: Trees ... > > > Well, I don't know how to transform the existing data from Parent_id-Trees > to that left/right-Structure. But I think you are right ... i > can't run away > from graph theory ;-) > > Regards > Thomas > > > ------------------------------------------- > Thomas Eppler Internet Management > Projekte f�r vernetzte Kommunikation, Kollaboration und Projektarbeit im > Unternehmen > zur F�rderung von Wissensaustausch, situativem Lernen und kollaborativem > Arbeiten > Postadresse: Grossackerstrasse 65, CH - 8041 Z�rich > Email: [EMAIL PROTECTED] > Web: http://www.internetmanagement.ch/ > > > > -----Urspr�ngliche Nachricht----- > Von: Cameron Childress [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 29. September 2002 19:39 > An: SQL > Betreff: RE: Trees ... > > > Is there a specific reason you can't use Celko's Nested Set Model? I > haven't yet found anything faster or better than that... > > -Cameron > > ----------------- > Cameron Childress > Sumo Consulting Inc. > --- > cell: 678-637-5072 > aim: cameroncf > email: [EMAIL PROTECTED] > > > > -----Original Message----- > > From: Thomas Eppler [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, September 29, 2002 4:49 AM > > To: SQL > > Subject: Trees ... > > > > > > Hello alltogether > > Does anyone of you have "the best" solution for getting a tree > > structure out > > of a table by using only one query? > > I mean a simple tree structure only using a Parent-ID - and not > a tree set > > up by using graph theory (e.g. see > > http://www.intelligententerprise.com/001020/celko.shtml) > > > > I still use this CF_tree-Tag, but with bigger amounts of data > it gets very > > slow. > > So what I need is a quick SQL statement which gets me the nodes > on level 1 > > sorted by data and all the other nodes sorted by ID (so the logical > > structure keeps alive). > > > > Also as I saw in the manual, there seem to be functions within > > Transact-SQL > > which deal with tree structures ... > > > > Any hint or idea will be appreciated - also general hints on > how to handle > > tree structures ... to be honest for years I am looking for > > better solutions > > .. > > > > Regards > > Thomas > > http://www.internetmanagement.ch > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
