Changeset 27859 for trunk/ippTools/share/pstamptool_completedreq.sql

Timestamp:

May 4, 2010, 4:10:59 PM (16 years ago)

Author:

watersc1

Message:

Fix typos in pstamptool database queries.
Add pstampDependent.outdir entry to changes.txt.

Final tested code for detectability server.
Works on test cases that involve updates.

r

File:

• trunk/ippTools/share/pstamptool_completedreq.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_completedreq.sql

@@ -1 +1 @@
 SELECT pstampRequest.* ,
-    IFNULL(labels.priority, 0) AS priority
+    IFNULL(Label.priority, 0) AS priority
 FROM pstampRequest 
-    LEFT JOIN labels USING(label) 
+    LEFT JOIN Label USING(label) 
 WHERE state = 'run'
     AND (