Mercurial > p > roundup > code
diff roundup/backends/rdbms_common.py @ 1550:905f92b97d4e maint-0.5
backport of mail address case problem from HEAD
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Mon, 24 Mar 2003 04:53:15 +0000 |
| parents | c8a596aa5aba |
| children | 44319ba5a7a7 |
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py Fri Mar 21 21:43:04 2003 +0000 +++ b/roundup/backends/rdbms_common.py Mon Mar 24 04:53:15 2003 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.27.2.7 2003-03-14 02:52:03 richard Exp $ +# $Id: rdbms_common.py,v 1.27.2.8 2003-03-24 04:53:14 richard Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -1666,7 +1666,7 @@ args.append(requirements[propname].lower()) # generate the where clause - s = ' and '.join(['_%s=%s'%(col, self.db.arg) for col in where]) + s = ' and '.join(['lower(_%s)=%s'%(col, self.db.arg) for col in where]) sql = 'select id from _%s where %s'%(self.classname, s) self.db.sql(sql, tuple(args)) l = [x[0] for x in self.db.sql_fetchall()]