Changeset 24455 for trunk/DataStoreServer/scripts/dsprodindex

Timestamp:

Jun 16, 2009, 7:48:21 PM (17 years ago)

Author:

bills

Message:

Discovered that we need to explicitly add ORDER BY fileset_id in order to get the filesets
in a product listed in order of registration

File:

• trunk/DataStoreServer/scripts/dsprodindex (modified) (1 diff)

trunk/DataStoreServer/scripts/dsprodindex

@@ -80 +80 @@
 }
         
-$stmt = $dbh->prepare("SELECT * FROM dsFileset WHERE prod_id = $prod_id  $after_clause");
+$stmt = $dbh->prepare("SELECT * FROM dsFileset WHERE prod_id = $prod_id  $after_clause ORDER BY fileset_id");
 $stmt->execute();