Providing your database has the upper() function, or replace with similar
select ...
<dtml-sqlgroup where>
<dtml-if firstname>
upper(firstname) like upper(<dtml-sqlvar firstname type=string>)
</dtml-if>
<dtml-or>
<dtml-if lastname>
upper(lastname) like upper(<dtml-sqlvar lastname type=string>)
</dtml-if>
<dtml-or>
...etc...
</dtml-sqlgroup>
On 06/09/07, Jaroslav Lukesh <[EMAIL PROTECTED]> wrote:
>
> Use MS-SQL or Sybase :o)
>
> ----- Original Message -----
> From: "onsombal" <[EMAIL PROTECTED]>
> >
> > 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>
> >
> _______________________________________________
> Zope maillist - [email protected]
> http://mail.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )
>
_______________________________________________
Zope maillist - [email protected]
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
