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