Hello, I tried to make some parts of a SELECT optional. The arguments list reads like: "arg1:int=0" The SQL statement is SELECT * FROM DATA <dtml-sqlgroup where> <dtml-if arg1> <stml-sqltest arg1 type=int> </dtml-if> </dtml-sqlgroup> When I run the test of this ZSQL object it ALWAYS got a WHERE clause testing for arg1 like: SELECT * FROM DATA WHERE ARG1=0 I thought this could never happen, due to the if construct. When I change the if to <dtml-if "arg1 != 0"> the SQL generated is till the same as above. Any ideas? Thanks Ulli -- ----------------- Die Website Effizienzer ------------------ luna-park Bravo Sanchez, Vollmert, Wisser GbR Ulrich Wisser mailto:u.wisser@luna-park.de Alter Schlachthof, Immenburgstr. 20 Tel +49-228-9654055 D-53121 Bonn Fax +49-228-9654057 ------------------http://www.luna-park.de ------------------
participants (1)
-
Ulrich Wisser