Thanks for the hint! A small example would be nice, if it's not too much trouble! Lance -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Saturday, June 10, 2000 2:26 AM To: Lance Kurisaki Cc: zope@zope.org 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: http://www.zope.org/Members/anthony/tree-coding->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. Regards Tino Wildenhain __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com