Changeset 2222 for pykota/trunk/pykota/storages/sql.py

Timestamp:

04/29/05 10:00:06 (19 years ago)

Author:

jerome

Message:

Fixed history retrieval for nonexisting printers or users

Files:

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

pykota/trunk/pykota/storages/sql.py

@@ -502 +502 @@
         query = "SELECT jobhistory.*,username,printername FROM jobhistory,users,printers WHERE users.id=userid AND printers.id=printerid"
         where = []
-        if (user is not None) and user.Exists :
+        if user is not None : # user.ident is None anyway if user doesn't exist
             where.append("userid=%s" % self.doQuote(user.ident))
-        if (printer is not None) and printer.Exists :
+        if printer is not None : # printer.ident is None anyway if printer doesn't exist
             where.append("printerid=%s" % self.doQuote(printer.ident))
         if hostname is not None :