changeset 183:8bbf8900273d

more utf8ify for member keys again :-(
author casties
date Thu, 13 Jun 2013 17:57:37 +0200
parents a743e22a155a
children 2802941bbe2d
files MPIWGProjects.py
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/MPIWGProjects.py	Wed Jun 12 15:10:18 2013 +0200
+++ b/MPIWGProjects.py	Thu Jun 13 17:57:37 2013 +0200
@@ -1833,7 +1833,7 @@
                 continue
                         
             # fill projects_members table
-            self.executeZSQL("insert into projects_members (project_id, member_key) values (%s, %s)", (pid, memberKey))
+            self.executeZSQL("insert into projects_members (project_id, member_key) values (%s, %s)", (pid, utf8ify(memberKey)))
     
     
 
@@ -1932,7 +1932,7 @@
         """
         projects = []
         # search project numbers
-        res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()])
+        res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [utf8ify(key).lower()])
         # find projects in folder
         for r in res:
             p = self.get(r.project_id, None)