diff MPIWGStaff.py @ 80:b1893c4c9d2c

more display of project pages.
author casties
date Wed, 08 May 2013 19:59:25 +0200
parents 7f26c8e6c8e9
children 271cf05a8648
line wrap: on
line diff
--- a/MPIWGStaff.py	Wed May 08 17:03:50 2013 +0200
+++ b/MPIWGStaff.py	Wed May 08 19:59:25 2013 +0200
@@ -1741,13 +1741,10 @@
             logging.error(escidocid)
             logging.error(value)
             
+
     def getSelectedPublications(self):
         """hole publications aus der datenbank"""
-    
-    
         query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority DESC"
-            
-           
         return self.executeZSQL(query,[self.getKey()])
     
     
@@ -1756,17 +1753,14 @@
         
         ret=""
         #founds=self.ZSQLInlineSearch(_table='research_interest',key_main=person.getKeyUTF8())
-        founds=self.ZSQLInlineSearch(_table='research_interest',key_main=self.getKey())
+        founds=self.executeZSQL('select * from research_interest where lower(key_main) = %s', [self.getKey().lower()])
         if founds:
             ret="<p class=\"bio_section_header\">Research interests: </p><br/>"
         for found in self.sortPriority(founds):
             ret+=found.interest+"<br/>"
-        
-        
         if (self.content.current_work) and (not self.content.current_work==""):
             ret+="<p class=\"bio_section_header\">Current work: </p><br/>"
-      
-            ret+=self.current_work+"<br/>"
+            ret+=self.content.current_work+"<br/>"
         if (self.content.cv) and (not self.content.cv==""):
             ret+="<p class=\"bio_section_header\">Curriculum Vitae: </p><br/>"
         ret+=self.formatAscii(self.content.cv)