Re: case insensitive ZSQL queries

onsombal <[email protected]> Thu, 6 Sep 2007 05:18:45 -0700 (PDT)

Newsgroups	gmane.comp.web.zope.database
Message-ID	<[email protected]>

thanks -- it now works like a charm....


Garry Saddington wrote:
> 
> 
> 
> 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
> 
> _______________________________________________
> Zope-DB mailing list
> [email protected]
> http://mail.zope.org/mailman/listinfo/zope-db
> 
> 

-- 
View this message in context: http://www.nabble.com/case-insensitive-ZSQL-queries-tf4388729.html#a12521162
Sent from the Zope - DB mailing list archive at Nabble.com.