Mailing List Archive: case insensitive ZSQL queries

case insensitive ZSQL queries

Sep 5, 2007, 4:16 PM

Post #1 of 4 (3841 views)

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

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

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: case insensitive ZSQL queries [ In reply to ]

garry at schoolteachers

Sep 6, 2007, 12:10 AM

Post #2 of 4 (3674 views)

Permalink

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
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: case insensitive ZSQL queries [ In reply to ]

onsombal at yahoo

Sep 6, 2007, 5:18 AM

Post #3 of 4 (3654 views)

Permalink

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
> Zope-DB@zope.org
> 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.

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: case insensitive ZSQL queries [ In reply to ]

maciej.wisniowski at coig

Sep 6, 2007, 5:32 AM

Post #4 of 4 (3647 views)

Permalink

> thanks -- it now works like a charm....
>
AFAIR 'ilike' in postgres doesn't properly support
i18n characters, so be carefull with that.

--
Maciej Wisniowski
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db