Changeset 21098 for trunk/ippTools/src/difftool.c

Timestamp:

Jan 9, 2009, 10:08:38 AM (17 years ago)

Author:

bills

Message:

where clauses for stack tables were in the wrong part of the query

File:

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

trunk/ippTools/src/difftool.c

@@ -1003 +1003 @@
     if (psListLength(stackWhere->list)) {
         psString whereClause = psDBGenerateWhereConditionSQL(stackWhere, NULL);
-        psStringAppend(&stackQuery, "\nAND %s", whereClause);
+        psStringAppend(&stackQuery, "\nWHERE %s", whereClause);
         psFree(whereClause);
     } else {
@@ -1112 +1112 @@
             return false;
         }
-        if (!p_psDBRunQuery(config->dbh, skycell_query, warp_id, filter, warpQuery, stackQuery)) {
+        if (!p_psDBRunQuery(config->dbh, skycell_query, stackQuery, warp_id, filter, warpQuery)) {
             psError(PS_ERR_UNKNOWN, false, "database error");
             psFree(warpQuery);