Changeset 3388 for pykota

Timestamp:

07/01/08 10:54:21 (16 years ago)

Author:

jerome

Message:

Fixed an SQL incompatibilities problem, thanks to Jens Weibler.
Fixes #17.

Files:

• pykota/trunk/pykota/storages/sql.py (modified) (1 diff)

pykota/trunk/pykota/storages/sql.py

@@ -345 +345 @@
     def getUserNbJobsFromHistory(self, user) :
         """Returns the number of jobs the user has in history."""
-        result = self.doSearch("SELECT COUNT(*) FROM jobhistory WHERE userid=%s" % self.doQuote(user.ident))
+        result = self.doSearch("SELECT COUNT(*) AS count FROM jobhistory WHERE userid=%s" % self.doQuote(user.ident))
         if result :
             return result[0]["count"]