[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 ------------------