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]

Reply via email to