Changeset 29998

Timestamp:

Dec 9, 2010, 12:03:31 PM (15 years ago)

Author:

rhenders

Message:

now getting

File:

• trunk/ippToPsps/perl/ippToPsps/IppToPspsDb.pm (modified) (2 diffs)

trunk/ippToPsps/perl/ippToPsps/IppToPspsDb.pm

@@ -127 +127 @@
 
     my $query = $self->{_db}->prepare(<<SQL);
-    SELECT distinct exp_id 
+    SELECT batch_id, exp_id 
         FROM batches 
         WHERE exp_id >= $fromExp
@@ -135 +135 @@
         AND datastore_product = '$datastoreProduct' 
         AND !merged
+        GROUP BY exp_id
 SQL