[Zope] ZSQL and REQUEST variables

[Ulrich Wisser]

Hello,

I defined a ZSQL method with two optional arguments

categoryconfig:int=0 entryid:int=0

SELECT * FROM DIRECTORYSUBMIT_ENTRIES 
<dtml-sqlgroup where>
  <dtml-if entryid>
     <dtml-sqltest entryid column=id type=int>
  </dtml-if>
  <dtml-and>
  <dtml-if categoryconfig>
    <dtml-sqltest categoryconfig type=int>
  </dtml-if>
</dtml-sqlgroup>

When I call the test interface like

http://server/sqlListDirEntries/manage_test?categoryconfig%3Aint=0&entryid%3Aint=0&SUBMIT=Submit+Query

(note the "%3Aint") evrything works. The resulting SQL statement is

SELECT * FROM DIRECTORYSUBMIT_ENTRIES 

When I call 

http://server/sqlListDirEntries/manage_test?categoryconfig=0&entryid=0&SUBMIT=Submit+Query

(noew "%3Aint" is missing) I get

SELECT * FROM DIRECTORYSUBMIT_ENTRIES 
where
(id=0
 and categoryconfig=0
)

What would be the correct if clause?

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