[Zope] Z SQL Method Question

Donald Braman donald.braman@yale.edu
Tue, 27 Feb 2001 14:47:49 -0500


I'm trying to build a query with three optional variables and three 
optional operators. I think I have a form that supplies the variables 
correctly, but am less certain about DTML use in a SQL query. Here's 
what I'm doing:

SELECT * FROM cases
WHERE makepublic = 't'
<dtml-if citationin>AND citation <dtml-var citationop> citationin 
</dtml-if>
<dtml-if casenamein>AND casenameshort <dtml-var casenameop> casenamein 
</dtml-if>
<dtml-if yearin>AND year <dtml-var yearop> yearin </dtml-if>

Any help/tips/advice appreciated.

Donald Braman
donald.braman@yale.edu