[Zope-DB] sqltest and sqlgroup

Matthew T. Kromer matt@zope.com
Tue, 15 Jan 2002 10:24:07 -0500


Dario Lopez-K=E4sten wrote:

>
>It's been like this forever - IIRC there was an entry for this in the
>oldcollector, but I could be mistaken. No fix that I know of, or... mayb=
e
>using a construct like this:
>
> select * from referrals
> where
> <dtml-if title>
>  title=3D<dtml-sqlvar title type=3Dstring>
> </dtml-if>
> <dtml-if forename>
>  and forename=3D<dtml-sqlvar forename type=3Dstring>
> </dtml-if>
> <dtml-if surename>
>  and surename=3D<dtml-sqlvar surname type=3Dstring>
> </dtml-if>
>
>this is untested and really ugly, though I hope this helps...
>
>/dario
>


Use   type=3D"nb"   for a non-blank string

>