Changeset 21412 for trunk/ippTools/src/pstamptool.c

Timestamp:

Feb 6, 2009, 5:48:20 PM (17 years ago)

Author:

bills

Message:

in job listings include some information from pstampProduct

File:

• trunk/ippTools/src/pstamptool.c (modified) (2 diffs)

trunk/ippTools/src/pstamptool.c

@@ -574 +574 @@
         psStringAppend(&query,
                 "SELECT"
-                " *"
+                " pstampJob.*, pstampRequest.name, pstampRequest.outProduct"
                 " FROM pstampJob"
+                " JOIN pstampRequest USING(req_id)"
                 " WHERE req_id = %" PRId64, req_id
             );
@@ -581 +582 @@
         psStringAppend(&query,
                 "SELECT"
-                " *"
+                " pstampJob.*, pstampRequest.name, pstampRequest.outProduct"
                 " FROM pstampJob"
+                " JOIN pstampRequest USING(req_id)"
                 " WHERE job_id = %" PRId64, job_id
             );