Changeset 25281 for trunk

Timestamp:

Sep 8, 2009, 12:55:01 PM (17 years ago)

Author:

bills

Message:

move sql for -completedreq to a sql file. Fix crash when limit is
supplied

Location:

trunk/ippTools

Files:

• share/pstamptool_completedreq.sql (added)
• src/pstamptool.c (modified) (1 diff)

trunk/ippTools/src/pstamptool.c

@@ -383 +383 @@
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
 
-    psString query = 
-        "SELECT * FROM pstampRequest WHERE state = 'run' AND "
-            "(SELECT count(*) FROM pstampJob WHERE pstampJob.req_id = pstampRequest.req_id "
-            " AND pstampJob.state != 'stop') = 0" ;
+    psString query = pxDataGet("pstamptool_completedreq.sql");
 
     // treat limit == 0 as "no limit"