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!
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!