Changeset 18203

Timestamp:

Jun 19, 2008, 1:59:32 PM (18 years ago)

Author:

jhoblitt

Message:

invert exposure sort order such that the newest data (by dateobs) is downloaded
first

Location:

trunk/ippTools

Files:

• share/pztool_pendingimfile.sql (modified) (1 diff)
• src/pztool.c (modified) (2 diffs)

trunk/ippTools/share/pztool_pendingimfile.sql

@@ -19 +19 @@
         AND pzDownloadImfile.class_id IS NULL
     ORDER BY
-        summitExp.dateobs
+        summitExp.dateobs DESC
 ) as Foo

trunk/ippTools/src/pztool.c

@@ -225 +225 @@
     }
 
+    psStringAppend(&query, " ORDER BY summitExp.dateobs DESC");
+
     // treat limit == 0 as "no limit"
     if (limit) {
@@ -295 +297 @@
             psFree(whereClause);
         }
+
+        psStringAppend(&query, " ORDERY BY summitExp.dateobs DESC");
 
         // request the full "limit" from each known camera and throw away any