[Zope] dtml-tree and Z SQL methods

[Anthony Baxter]

>>> Ragnar Beer wrote
> Does anyone know how to display hierarchical content from SQL? I was 
> hoping to find the answer in the "Secrets of working with the tree 
> tag"-HOWTO but appearently it's not yet in there.
> 
> What I have in (My)SQL is a table with:
> cont_id     - Unique ID (primary key) of a container
> upper_id    - ID of the upper container or NULL
>                (the container containing this container;)
> description - text to be displayed describing the container

Have a look at my (still incomplete) howto on some more tree tricks.
This particular problem is answered there. 
(No, it's not cataloged, as it's really not finished yet. Feedback 
appreciated).

http://www.zope.org/Members/anthony/tree-coding-tricks

Anthony