Changeset 3393 for pykota/branches

Show
Ignore:
Timestamp:
07/10/08 21:31:52 (16 years ago)
Author:
jerome
Message:

Backported a fix for a minor PostgreSQL/MySQL incompatibility.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/branches/1.26_fixes/pykota/storages/sql.py

    r3184 r3393  
    345345    def getUserNbJobsFromHistory(self, user) : 
    346346        """Returns the number of jobs the user has in history.""" 
    347         result = self.doSearch("SELECT COUNT(*) FROM jobhistory WHERE userid=%s" % self.doQuote(user.ident)) 
     347        result = self.doSearch("SELECT COUNT(*) AS count FROM jobhistory WHERE userid=%s" % self.doQuote(user.ident)) 
    348348        if result : 
    349349            return result[0]["count"]