>- see footer for list info -< If you can get your hands on SQL 2008 it has a brand new hierarchy datatype which is supposed to be optimised for this sort of thing. (Yeah, I know what wasn't the question)
Gary F. On Thu, Sep 4, 2008 at 11:05 PM, Lee Fortnam <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > Thanks Nick, > > I eventually stumbled upon this which is pretty much going to do everything > I needed, guess it was just a question of knowing what to look for!!! > > This is a Coldfusion library to deal with nested set model: > http://stannard.net.au/blog/page.cfm/nested-set-trees > > I have copied the CFDev group in just in case it is of use to other people! > > Once again, many thanks > > Lee > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Nick de Voil > Sent: 04 September 2008 20:57 > To: database programming > Subject: Re: [CF-Database] Organisation hierarchy in MS SQL 2005 > > > I have a client how needs to be able to hold the structure of various > > organisations in a database, the problem is, each of the organisations has > a > > completely different hierarchy structure and an unlimited number of > levels. > > Try the nested set model. > > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > > Nick > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com <http://www.gradwell.com/> -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com <http://www.gradwell.com/> -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
