[Zope] dtml-tree and Z SQL methods

[Ragnar Beer]

Thanks a lot! It was VERY easy with this howto. Another reply I got 
was to search the archives. There I had a big problem: "dtml-tree 
sql" as keywords returned >2000 messages where not every message had 
both terms in it. I guess the search-engine ORed the terms. Does 
anyone know how to tell the search-engine to AND them?

Ragnar

>  >>> 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