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

Reply via email to