[Zope] Re: [Zope-DB] case insensitive ZSQL queries

Jaroslav Lukesh lukesh at seznam.cz
Thu Sep 6 01:07:05 EDT 2007


Use MS-SQL or Sybase :o)

----- Original Message ----- 
From: "onsombal" <onsombal at yahoo.com>
> 
> 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>
> 


More information about the Zope mailing list