[Zope-DB] case insensitive ZSQL queries

onsombal onsombal at yahoo.com
Wed Sep 5 19:16:26 EDT 2007


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.



More information about the Zope-DB mailing list