[Zope-DB] dtml-sqlgroup oddity

Philip Kilner phil at xfr.co.uk
Fri Nov 5 03:15:41 EST 2004

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

<dtml-sqlgroup where>
     <dtml-sqltest column="Forenames" name="ForenameParam" op="like" 
type="string" optional>
     <dtml-sqltest column="Surname" name="SurnameParam" op="like" 
type="string" optional>
     <dtml-sqltest column="CentreCandidateRef" name="CtrCandRef" op="eq" 
type="string" optional>
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?




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

More information about the Zope-DB mailing list