If your data is based upon parentid and uniqueid, then you will need to
change your data...
http://data.bangtech.com/sql/nested_set_treeview.htm
and once you've done that and find you can't deal with things (maybe it
isn't for you), then
http://pratchev.blogspot.com/2007/02/convert-tree-structure
""Arno Kuhl"" wrote in message
news:DB930522404B4552B8A15AF991C57E30@point01...
>
> Hi Jim. Only one linked list of parentids. No siblings.
> Multiple records can have the same parentid, but that doesn't play a role.
>
Okay. So you want only one 'family tree' at any given time, and a tree is a
> Hi Jim. I wanted the list of related parentids from current id to
> top-level
> (parentid=0).
Ah - now that is a much different question!
>From your statement above, are you now saying you only want ONE list of
related ids, not the entire society of possible 'families' in your table?
Als
On 28 July 2011 14:09, Arno Kuhl wrote:
>>
>> I have a table with an id and a parentid.
>> If it's a top-level record the parentid is 0, otherwise it points to
>> another record, and if that record isn't a top-level record its
>> parentid points to another record, etc (a linked list).
>>
>> Is the
""Arno Kuhl"" wrote in message
news:D349CC15D13F48DD8D4F6ED70062138C@point01...
> >
> Hi Jim. I wanted the list of related parentids from current id to
> top-level
> (parentid=0).
Ah - now that is a much different question!
>From your statement above, are you now saying you only want ONE
>
> I have a table with an id and a parentid.
> If it's a top-level record the parentid is 0, otherwise it points to
> another record, and if that record isn't a top-level record its
> parentid points to another record, etc (a linked list).
>
> Is there a single select that will return the comple
""Arno Kuhl"" wrote in message
news:487F03135D2B452B89F22C95E278C7D4@point01...
>
> I have a table with an id and a parentid.
> If it's a top-level record the parentid is 0, otherwise it points to
> another
> record, and if that record isn't a top-level record its parentid points to
> another r