[Zope] Help: Recursive querying

[Anthony Baxter]

>>> Tom Schwaller wrote
 
> > > SQL Method  sqlSelectChildren:
> > > ---
>
> There seems to be no answer to this question available yet (??), 
> although I'd like to find a solution (the above "solution" does
> not work..)

Actually, no, it does work.

I'm using it (well, a variation of it) quite happily every day.


> Maybe someone can give us a simpler example for building a tree
> with a database method (hope this is not a FAQ)? I remember having 
> seen something here a long time ago, but finding the right keywords 
> for a search in a Zope mail folder with over 9000 mails is not that easy
> ;-)

For Oracle users, also look at the 'connect by prior' arguments to
the select statement.

Anthony
--
Anthony Baxter     <anthony@interlink.com.au>   
It's never too late to have a happy childhood.