Changeset 36478 for trunk/ippMonitor

Timestamp:

Feb 5, 2014, 2:18:40 PM (12 years ago)

Author:

bills

Message:

missed a spot...

File:

• trunk/ippMonitor/czartool/czartool/Gpc1Db.pm (modified) (2 diffs)

trunk/ippMonitor/czartool/czartool/Gpc1Db.pm

@@ -233 +233 @@
         }
         else {
+            $query = $self->{_db}->prepare(<<SQL);
+            SELECT COUNT(state)
+                FROM $table
+                WHERE label LIKE '$label'
+                AND state = 'update'; 
+SQL
         
         }
@@ -254 +260 @@
                 FROM $table
                 WHERE label LIKE '$label'
-                AND state = 'new'; 
+                AND (state = 'new' OR state = 'update'); 
 SQL
         }