[Zope-DB] dtml-sqlgroup oddity

[Philip Kilner]

Hi All,

I've been happily using the <dtml-sqlgroup> tag, but I now have a method 
where all parameters are passed, whether supplied or not. The code is: -

select * from V_CANDIDATE_REGISTRATION
<dtml-sqlgroup where>
     <dtml-sqltest column="Forenames" name="ForenameParam" op="like" 
type="string" optional>
   <dtml-and>
     <dtml-sqltest column="Surname" name="SurnameParam" op="like" 
type="string" optional>
   <dtml-and>
     <dtml-sqltest column="CentreCandidateRef" name="CtrCandRef" op="eq" 
type="string" optional>
</dtml-sqlgroup>
order by RegistrationID desc

The fails unless all parameters are supplied, because it is testing 
against an empty string for missing parameters.

I'm assuming that I've made a typo or otherwise done something else 
subtle - can anyone spot what's wrong?


-- 

Regards,

PhilK

Email: phil at xfr.co.uk / Voicemail & Facsimile: 07092 070518

"Work as if you lived in the early days of a better nation." - Alasdair Gray