>- 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 -< >- 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 -<
