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? Halinux
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
Horvath Adam writes:
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 >='--' Use an "dtml-if" to check for the empty condition.
Dieter
participants (3)
-
Dieter Maurer -
hans -
Horvath Adam