Home
The Toolkit for Online Communities
17127 Community Members, 2 members online, 1903 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Development : Hierarchical query in Oracle - prvileges tree : One Message

Forum OpenACS Development: Re: Hierarchical query in Oracle - prvileges tree

Collapse
Posted by Tilmann Singer on
Well I'd like to display the tree the way it is, not orderd by levels. This modification returns:

TREE_LEVEL PRIVILEGE            CHILD_PRIVILEGE
---------- -------------------- --------------------
         0                      another_top_level
         0                      one_top_level
         1 one_top_level        sub_level
         2 sub_level            sub_sub_level

but the two first lines are not determined by the hierarchy but by hte alphabetical ordering of their names, e.g. if the parent of 'sub_level' was 'another_top_level', it would still appear on that position which is wrong.