Hi,
Any ideas would be appreciated:
I've got db content with an ID and a parentID. parentID can be null
denoting a top of the tree piece of content. So I could have a content
tree like:
ID: 1 ParentID: NULL
>ID: 2 ParentID: 1
>ID: 3 ParentID: 2
Potentially ad infinitum.
The question is how would I create a query that could select the IDs for
this lineage if I am starting with the lowest rung ID of 3.
In short I'm trying to create a crumbtrail dynamically and I don't want
to limit it to three rungs...
Cheers
d
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]