[Zope] The tree tag, SQL and what should be simple

Rik Hoekstra rik.hoekstra@inghist.nl
Thu, 24 Aug 2000 21:13:04 +0200


>
>
>I thought this was going to be simple but having read numerous postings on
the
>mailing list and all related HOW-TOs I can find, I think I can confirm I am
>stuck. This is sad because I've just spent a very productive couple of days
with
>Zope and MySQL making the world a better place.
>
>I have a table for chickens. Basically it looks like this


<snip sql>

>It would appear that I need to feed two things to the dtml-tree tag.
Firstly my
>starting levels (my types) and then the related data underneath but I can
only
>feed one SQL query to the tag. All the stuff I read seems to assume the
info at
>the top level comes from the same file (and from a key id). How do I do
this or
>indeed, is it possible? I have a nasty feeling I am missing something
obvious.
>

Unless I do not quite understand you I think you missed Anthony Baxter's
tree_and_sql howto
(http://www.zope.org/Members/anthony/tree-coding-tricks ). It will probably
give you either exactly what you want or enough ideas to get you further.

hth

Rik