[Zope] Tree Tag & SQL

[Paul Everitt]

Ron wrote:
> Problem: how to have the tree tag use a different SQL method 
> for each level 
> WITHOUT resorting to external methods, because the directory 
> should be 
> maintainable by mere mortals, not Python or SQL gods.

Hi Ron.  Just a guess, but how about having the tree tag pass in the the
current level as an argument to the same SQL method, then have the SQL
method adapt itself based on the argument?  Remember that an SQL method
can embed logic and act like an object using DTML.  For instance:

<!--#if "level==1"-->
  select ...
<!--#elif "level==2"-->
  select ...
etc.

--Paul