[Zope] ZSQL namespace
Ulrich Wisser
u.wisser@luna-park.de
Mon, 13 Dec 1999 11:36:02 +0100
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 ------------------