[Zope] a newbie in trouble with tree tag and sql methods

[Graham Chiu]

In article <LQp7BCADGKg3EwFV@compkarori.co.nz>, Graham Chiu <anon_emouse@hotmail.com>
writes
>Unfortunately I can infinitely expand the tree whereas I want to stop it at one
>expansion.

Well, I've solved my problem ( with some help from Tone ) by using another variable to
produce an empty query which stops the tree from expanding.

Here's the working code though I wonder whether I can optimise it a bit more.

Zsqlmethod:sqlTestTree param:string flag:int

<!--#if "param==''"-->
select distinct userid as obj_id, '' as path, '' as qstring, 
'' as description, 0 as flag  from url order by userid
<!--#else-->
  <!--#if "flag==0"-->
select userid as obj_id, path, qstring, description, 1 as flag
from url where
<!--#sqltest param column=userid type=nb-->
  <!--#else-->
select * from url where userid=''
  <!--#/if-->
<!--#/if-->


The line "select * from url where userid=''" should always return an empty set for this to
work.

and the dtml...

<!--#with "_.namespace(obj_id='', flag=0)"-->
  <!--#tree id=obj_id branches_expr="sqlTestTree(param=obj_id, flag=flag)" single=0-->
    <!--#if "path==''"-->
      <!--#var obj_id-->
    <!--#else-->
       <a href=<!--#var path-->?<!--#var qstring-->><!--#var description--></a><br>
    <!--#/if-->
  <!--#/tree-->
<!--#/with-->

-------
Regards,        Graham Chiu
gchiu<at>compkarori.co.nz