CF_TwoSelectsRelated Question, Related Drop down menu

[mike2277]

Hi all,
I am working on a two-select related drop down menu.

I have been using a coldfusion custom tag which is called CF_TwoSelectsRelated for a while, that works well for me. But I couldn’t figure out a way to write this query to be used in CF_TwoSelectsRelated.

Here is my table structure:

pageid parented pagelevel
1 0 1
2 1 2
3 2 3
4 2 3
5 2 3

I need write ONE query to get the hierarchy structure of the page tree, and then use the cf_twoselectsrelated to retrieve them.

Thank you in advanced for any help!

 

[NorthStarDA]

depending on the size of your table, you may want to re-think the way you store the data

http://www.ecodebank.com/prints/?catid=17&catsubid=0&nid=121

left and right extents are far much more versatile than the 'parentID' relationship

=========================================
Don't sweat the petty things and don't pet the sweaty things.

 

[philhege]

Also, TwoSelectsRelated isn't well suited for hierarchical trees. It'd be hard to answer the question "Who's my parent?" with the custom tag alone.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[771212]

Thank you for the post, i think I figure out the way to write the query.
I used INNER JOIN in the query to realize that.