[Zope] Help: Recursive querying
Anthony Baxter
Anthony Baxter <anthony@interlink.com.au>
Fri, 13 Aug 1999 08:53:36 +1000
>>> 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.