Changeset 21443 for trunk/ippTools/src/camtool.c

Timestamp:

Feb 11, 2009, 3:08:59 PM (17 years ago)

Author:

bills

Message:

in -processedexp mode order results by cam_id so the postage stamp request
parser can easily find the 'latest' astrometry for an exposure.

File:

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

trunk/ippTools/src/camtool.c

@@ -655 +655 @@
     }
 
-    // use psDBGenerateWhereConditionalSQL with AND ... because the SQL ends in a WHERE
     if (psListLength(where->list)) {
         psString whereClause = psDBGenerateWhereConditionSQL(where, NULL);
-        psStringAppend(&query, " AND %s", whereClause);
+        psStringAppend(&query, " WHERE %s", whereClause);
         psFree(whereClause);
     }
@@ -677 +676 @@
         psFree(limitString);
     }
+
+    // order by cam_id so that the postage stamp parser can easliy find the 'latest' astrometry
+    psStringAppend(&query, "\nORDER BY cam_id");
 
     if (!p_psDBRunQuery(config->dbh, query)) {