[Zope-DB] Making case-insensitive in sqlgroup

Joshua Burvill josh at mri.com.au
Mon Nov 1 16:26:32 EST 2004


Hello to everyone,

I am using zope 2.6.4, firebird 1.0, and kinterbasdbda and I would like to
make the following query case-insensitive.

<dtml-sqlgroup where>
...
<dtml-sqltest location op=eq type=nb optional>
<dtml-and>
...
</dtml-sqlgroup>


If I was not using the convenient sqlgroup syntax, I would probably use
something like:

where upper(location) = upper( <dtml-sqlvar location type=string> )


Does anyone know how to do this?

Regards, Josh




More information about the Zope-DB mailing list