Forum OpenACS Development: Re: nesting and list-builder
Considering I just barely grok list builder at this point, I don't think I should be hacking on it. I might accidentally do something like rewrite the UI to make it actually easy for mere mortals to use. ;) I do intend to put my work into project manager, provided Jade agrees, and if someone who is more comfortable with list builder internals, and has more time, wants to take it and add it in I'd be happy to answer questions. But I can't do it myself right now.
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 (http://web.uvic.ca/~erempel/tcl/tree/tree.html) to do this once. It wasn't fast, but it worked.