[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: -
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
More information about the Zope-DB
mailing list