Forum OpenACS Development: Re: nesting and list-builder

Posted by Andrew Grumet on
<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 ...

Here's a "cheat":  load the three into memory and sort it there.  I think used the tree package ( to do this once.  It wasn't fast, but it worked.

Posted by Dirk Gomez on
That's not try anymore for Oracle >= 9i. There is an order by siblings (and some other order by goodies).