[Zope] optional sql tag

[hans]

Horvath Adam wrote:

> Hi,
>
> I have 3 select -> there are 3 form variable: year, month,
> day
> which are arguments for the ZSQL Method:
>
> select * from table c
> <dtml-sqlgroup where>
>   ...
> <dtml-and>
>   c.date >= <dtml-sqlvar "year+'-'+month+'-'+day"
> type=string>
> <dtml-and>
>   ...
> </dtml-sqlgroup>
>
> It works great, but when there is nothing in the form
> variables,
> it will be  c.date >='--'
>
> How can I do that with empty form variables this <dtml-
> and> tag
> would be optional?

heard rumors about some <dtml-sqltest> tag

-------------------------------------------------------------
Who's got only a hammer sees the world as a nail
hans augustin  (software developer)           hans@beehive.de
beehive elektronische medien GmbH       http://www.beehive.de
phone: +49 30 847-82 0                  fax: +49 30 847-82 299