[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
>