22 Mar
2002
22 Mar
'02
10:20 p.m.
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