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)