[Zope-DB] how to get all values if input is not defined?

[Michael Mauws]

An easy way to deal with this is using dtml-if:

<dtml-if A>
  SELECT * FROM X WHERE FIELD1 = <dtml-sqlvar A type=string>
<dtml-else>
  SELECT * FROM X
</dtml-if>