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]