Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: DB
case insensitive ZSQL queries
 

Index | Next | Previous | View Flat


onsombal at yahoo

Sep 5, 2007, 4:16 PM


Views: 1727
Permalink
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[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Subject User Time
case insensitive ZSQL queries onsombal at yahoo Sep 5, 2007, 4:16 PM
    Re: case insensitive ZSQL queries garry at schoolteachers Sep 6, 2007, 12:10 AM
        Re: case insensitive ZSQL queries onsombal at yahoo Sep 6, 2007, 5:18 AM
            Re: case insensitive ZSQL queries maciej.wisniowski at coig Sep 6, 2007, 5:32 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.