RE: displaying a tree structure

2009-03-04 Thread Chad Gray
Oh... interesting. Would be nice to do it in SQL. I will study this. Thanks Donnie! > -Original Message- > From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] > Sent: Wednesday, March 04, 2009 9:52 AM > To: cf-talk > Subject: Re: displaying a tree struct

RE: displaying a tree structure

2009-03-04 Thread Chad Gray
Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Tuesday, March 03, 2009 8:05 PM > To: cf-talk > Subject: displaying a tree structure > > > I have data in a table like this: > > IDParentIDName > 1 0 Top &g

Re: displaying a tree structure

2009-03-04 Thread Donnie Carvajal
> I have data in a table like this: > > IDParentIDName > 1 0 Top > 2 1 Level1 > 3 1 Level2 > 4 2 Child1 Of Level2 > 5 2 Child2 Of Level2 > 6 3 Child1 Of Level2 > > So the tree

Re: displaying a tree structure

2009-03-03 Thread Maureen
Use the group-by function. On Tue, Mar 3, 2009 at 5:04 PM, Chad Gray wrote: > > I have data in a table like this: > > ID      ParentID        Name > 1       0               Top > 2       1               Level1 > 3       1               Level2 > 4       2               Child1 Of Level2 > 5      

displaying a tree structure

2009-03-03 Thread Chad Gray
I have data in a table like this: ID ParentIDName 1 0 Top 2 1 Level1 3 1 Level2 4 2 Child1 Of Level2 5 2 Child2 Of Level2 6 3 Child1 Of Level2 So the tree would lo