A discussion on this went on just last week. Check the archives. Searching for ''nested set'' should bring it up.
I wrote a freebie, ultra-basic cms that handles it in three different ways, depending on your resources. Tear it up to see how it works. http://makeashorterlink.com/?E19D21CF One of those three methods uses cfx_fmaketree, also available free in the dev exchange, that makes short work of the whole business. Those archives I mentioned should point to a non-cfx way to do the same thing as the cfx, created by this list's host. Cheers, --------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --------------------------------------- ---------- Original Message ---------------------------------- from: <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 3 Jun 2002 17:24:37 -0400 Hello- I'm just starting to get into heirarchal data and I was wondering if anyone could provide some insight into how to handle the looping and naming conventions... Rather than re-invent the wheel. Thanks in advance! -Lou ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists