Changeset 11572

Timestamp:

Feb 1, 2007, 7:21:41 PM (19 years ago)

Author:

eugene

Message:

fixed errors related to exp_tag restrictions

File:

• trunk/ippTools/src/camtool.c (modified) (3 diffs)

trunk/ippTools/src/camtool.c

@@ -106 +106 @@
 
     if (config->where) {
-        psString whereClause = psDBGenerateWhereConditionSQL(config->where, NULL);
-        psStringAppend(&query, " %s", whereClause);
+        psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p3PendingExp");
+        psStringAppend(&query, " AND %s", whereClause);
         psFree(whereClause);
     }
@@ -169 +169 @@
             "   rawExp.workdir"   
             " FROM p3PendingExp"
+            " JOIN p2ProcessedImfile"
+            "   USING(exp_tag, p2_version)"
             " JOIN rawExp"
             "   USING(exp_tag)"
-            " JOIN p2ProcessedImfile"
-            "   USING(exp_tag, p2_version)"
             " LEFT JOIN p3ProcessedExp"
             "   USING(exp_tag)"
@@ -480 +480 @@
     if (config->where) {
         psString whereClause = psDBGenerateWhereConditionSQL(config->where, NULL);
-        psStringAppend(&query, " %s", whereClause);
+        psStringAppend(&query, " AND %s", whereClause);
         psFree(whereClause);
     }