Thanks for the hint! A small example would be nice, if it's not too much

-----Original Message-----
From: Tino Wildenhain [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 10, 2000 2:26 AM
To: Lance Kurisaki
Subject: Re: [Zope] Re: dtml-tree with data from multiple tables

Hi Lance,

Lance Kurisaki wrote:
> >>I'd like to generate a tree with data from different
> >>SQL tables depending on the tree level. In other
> >>words, the first level data  comes from one table,
> >>second level comes from another.
> >>
> >>How can the branches_expr expression determine what
> >>the current tree  level is? Can I pass a parameter
> to
> >>let me know the current level? I tried the
> following,
> >>but it didn't work...
> >>
> >>  <dtml-tree id=name
> branches_expr="child_lookup(_['tree-level'])">
> >
> >
> >I think Anthony baxter's "Some neat tricks with
> dtml->tree" <url:
> >>tricks
> > will help you out
> That How-To uses the same SQL table to define children
> at all levels of the tree. How can I use different
> tables at different levels? Am I able to determine the
> current level in my child_lookup() method?
I used a trick to archive this:

each of my tables has a number as key. <dtml-tree>
needs a unique id for lookup. So to make it unique,
I add an offset to each tables key and remove it for
query. My query is kind of self modifying for this,
comparing if the key is inside a given interval and making
the query at the appropriate table with removing the offset first
and adding the next offset to the results.

I can provide an example, if you wish.

Tino Wildenhain

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.

Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - )

Reply via email to