Changeset 3393 for pykota

Timestamp:

07/10/08 21:31:52 (16 years ago)

Author:

jerome

Message:

Backported a fix for a minor PostgreSQL/MySQL incompatibility.

Files:

• pykota/branches/1.26_fixes/pykota/storages/sql.py (modified) (1 diff)

pykota/branches/1.26_fixes/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"]