diff MPIWGStaff.py @ 53:e718d9a72f19

bibliographie funktionen
author dwinter
date Tue, 30 Apr 2013 16:31:57 +0200
parents f59bdd5f4890
children a6ace48c2bf2
line wrap: on
line diff
--- a/MPIWGStaff.py	Mon Apr 29 16:02:24 2013 +0200
+++ b/MPIWGStaff.py	Tue Apr 30 16:31:57 2013 +0200
@@ -1609,6 +1609,7 @@
             
             pubs=[]
             for selPub in selPubs:
+                logging.debug("searchFor:%s"%selPub.escidocid)
                 pubs.append((selPub.escidocid,self.mpiwgPubman.getEntryFromPubman(selPub.escidocid)))
                 
             return pubs
@@ -1712,7 +1713,7 @@
         """hole publications aus der datenbank"""
     
     
-        query="select * from pubmanbiblio where key_main = %s order by priority"
+        query="select * from pubmanbiblio where lower(key_main) = lower(%s) order by priority DESC"
             
            
         return self.executeZSQL(query,[self.getKey()])