Re: [Zope] dtml-tree and Z SQL methods
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
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
participants (2)
-
Anthony Baxter -
Ragnar Beer