Forum OpenACS Development: Re: nesting and list-builder

Collapse
13: Re: nesting and list-builder (response to 12)
Posted by Andrew Grumet on 11/17/04 05:20 PM
<blockquote>Claudio is correct, you can not maintain the tree
hierarchy and alphabetize in a single query.  Same's true
of CONNECT BY in Oracle.  Just can't be done ...
</blockquote>

Here's a "cheat":  load the three into memory and sort it there.  I think used the tree package (http://web.uvic.ca/~erempel/tcl/tree/tree.html) to do this once.  It wasn't fast, but it worked.

Collapse
14: Re: nesting and list-builder (response to 13)
Posted by Dirk Gomez on 11/17/04 06:26 PM
That's not try anymore for Oracle >= 9i. There is an order by siblings (and some other order by goodies).