[Zope] Simple problem with sql-group
Zanotti Michele
Zanotti@az.aziendasanitaria.trentino.it
Tue, 13 Mar 2001 17:16:22 +0100
Hello,
I 'm a Zope newbye. I have a (probably silly) problem with this sql-template
(if you have already discussed this problem excuse me):
select * from employees
<dtml-sqlgroup where>
<dtml-sqltest salary op=gt type=float optional>
<dtml-and>
<dtml-sqltest first op=eq type=string optional>
<dtml-and>
<dtml-sqltest last op=eq type=string optional>
</dtml-sqlgroup>
My question is:
if I pass the value 10000 to parameter salary (and nothing to others) I
expect to obtain the query:
select * from employees
where
(salary > 10000)?
But I obtain the query
select * from employees
where
(salary > 10000
and first = ''
and last = ''
).
Is this result correct and am I wrong?
Can you help me? Thanks.
Michele