Changeset 3388

Show
Ignore:
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:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/pykota/storages/sql.py

    r3302 r3388  
    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"]