Re: case insensitive ZSQL queries

garry saddington <[email protected]> Thu, 06 Sep 2007 08:10:30 +0100

Newsgroups	gmane.comp.web.zope.database
Message-ID	<1189062631.26161.0.camel@localhost>


On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote:
> is there an easy way to make the following ZSQL query case-insensitive?
> 
> select * from clients
> <dtml-sqlgroup where>
>     <dtml-sqltest firstname op="like" type="string" optional>
>   <dtml-or>
>     <dtml-sqltest lastname op="like" type="string" optional>
>   <dtml-or>
>     <dtml-sqltest client op="like" type="string" optional>
>   </dtml-sqlgroup>
> 
> Thanks... Jim
> 
> 
If you use Postgresql then change the 'like' to 'ilike'.
Regards
Garry