Mercurial > hg > MPIWGWeb
changeset 178:ee0fbb711f17
fix problem with mixed case person keys
author | casties |
---|---|
date | Tue, 11 Jun 2013 17:51:55 +0200 |
parents | a7be6992777e |
children | 136b2d5b3e3d |
files | MPIWGProjects.py |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/MPIWGProjects.py Tue Jun 11 14:46:52 2013 +0200 +++ b/MPIWGProjects.py Tue Jun 11 17:51:55 2013 +0200 @@ -1953,7 +1953,7 @@ """ members = [] sf = self.en.getStaffFolder() - res = self.executeZSQL("select distinct member_key from projects_members") + res = self.executeZSQL('select distinct lower(member_key) as "member_key" from projects_members') if onlyActive: for r in res: m = sf.getMember(key=r.member_key)