[Zope-CMF] ZSQL-ignore empty values?

Dieter Maurer dieter@handshake.de
Wed, 30 Oct 2002 20:04:39 +0100


Kelley, Sean writes:
 > ... ZSQL search ...
 > If I leave many of the form values blank I do
 > not want them included in the search due to the AND because I get no
 > results.
 > I am using MS SQL 7 and Zope v 2.5.1
 > ...
 >   <dtml-sqltest StreetName type=string op=like optional>  <dtml-and>
use "type=nb" (i.e. "non-blank") rather than "type=string".


Dieter