RE: SQL: hierarchical view of parent child categories

on CF5 or CFMX, it's really quite simple. Cheers, barneyb > -Original Message- > From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 10:43 AM > To: CF-Talk > Subject: RE: SQL: hierarchical view of parent child categories > > Thank

RE: SQL: hierarchical view of parent child categories

: CF-Talk Subject: Re: SQL: hierarchical view of parent child categories here's a good discussion of the topic: http://www.sitepoint.com/article/hierarchical-data-database/1 also google for Joe Celko --he has lots of information on the topic -- may have to do a bit of reading to dig it out

Re: SQL: hierarchical view of parent child categories

here's a good discussion of the topic: http://www.sitepoint.com/article/hierarchical-data-database/1 also google for Joe Celko --he has lots of information on the topic -- may have to do a bit of reading to dig it out, but it's there! Finally you might consider Xindice (an open source XML datab

SQL: hierarchical view of parent child categories

Hi all, Here's s sql stumper, well, not really.  But I haven't been able to figure out the best way to do it yet so I'm posting here.  I know it's sql but it does have CF implications. Scenario: I have a table called CATEGORY with the following columns ID PK for table PARENT_ID If populated i