Changeset 19492 for trunk/ippTools/share/chiptool_pendingimfile.sql

Timestamp:

Sep 11, 2008, 11:24:37 AM (18 years ago)

Author:

Paul Price

Message:

Need additional brackets, since additional restrictions may be added.

File:

• trunk/ippTools/share/chiptool_pendingimfile.sql (modified) (2 diffs)

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -20 +20 @@
     ON chipRun.label = chipMask.label
 WHERE
-    (chipRun.state = 'new'
+    ((chipRun.state = 'new'
     AND chipProcessedImfile.chip_id IS NULL
     AND chipProcessedImfile.exp_id IS NULL
@@ -27 +27 @@
     OR
     (chipRun.state = 'update'
-    AND chipProcessedImfile.data_state = 'cleaned')
+    AND chipProcessedImfile.data_state = 'cleaned'))