[Zope] Tree tag and SQL methods?

Alexander Staubo alex@mop.no
Wed, 9 Jun 1999 19:08:12 +0200


I don't have a head for figuring this out today, but maybe somebody here
can help me out.

I'm thinking of exploiting the #tree tag in conjunction with one or more
SQL method. Say I have a hierarchical-ish table with id/parent_id
references, and I'd like to display this information in a nice
collapsible tree. Possible? Possibly the expr= or branches_expr=
arguments to #tree could evaluate the result of an SQL method, although
it sounds to me like this would require one query per tree level.
Possibly you could put the query results of the complete table in a
temporary variable and evaluate on that?

Anybody done something like this?

--
Alexander Staubo             http://www.mop.no/~alex/
"`Ford, you're turning into a penguin. Stop it.'"
--Douglas Adams, _The Hitchhiker's Guide to the Galaxy_