Changeset 24456

Timestamp:

Jun 16, 2009, 9:15:25 PM (17 years ago)

Author:

Paul Price

Message:

Need to qualify columns with table names.

File:

• branches/pap_mops/ippTools/src/pubtool.c (modified) (1 diff)

branches/pap_mops/ippTools/src/pubtool.c

@@ -303 +303 @@
 
     psMetadata *where = psMetadataAlloc(); // WHERE conditions
-    PXOPT_COPY_S64(config->args, where, "-pub_id", "pub_id", "==");
-    PXOPT_COPY_S32(config->args, where, "-fault", "fault", "==");
-    PXOPT_COPY_STR(config->args, where, "-client_id", "client_id", "==");
-    PXOPT_COPY_STR(config->args, where, "-comment", "comment", "LIKE");
-    PXOPT_COPY_STR(config->args, where, "-label", "label", "==");
+    PXOPT_COPY_S64(config->args, where, "-pub_id", "publishRun.pub_id", "==");
+    PXOPT_COPY_S32(config->args, where, "-fault", "publishDone.fault", "==");
+    PXOPT_COPY_STR(config->args, where, "-client_id", "publishClient.client_id", "==");
+    PXOPT_COPY_STR(config->args, where, "-comment", "publishClient.comment", "LIKE");
+    PXOPT_COPY_STR(config->args, where, "-label", "publishRun.label", "==");
 
     psString query = pxDataGet("pubtool_revert.sql");