Re: [Zope-DB] case insensitive ZSQL queries
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: [Zope-DB] case insensitive ZSQL queries
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: [Zope-DB] case insensitive ZSQL queries
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
[Zope-DB] case insensitive ZSQL queries
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