Changeset 16954 for trunk/DataStoreServer/scripts/dsfsindex

Timestamp:

Mar 12, 2008, 11:15:16 AM (18 years ago)

Author:

bills

Message:

need to qualify selection by fileset by name with the product as well

File:

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

trunk/DataStoreServer/scripts/dsfsindex

@@ -41 +41 @@
 my $prod_id = $prod->{prod_id};
 
-my $stmt = $dbh->prepare("SELECT fileset_id FROM dsFileset WHERE fileset_name = \'$fileset\'");
+my $stmt = $dbh->prepare("SELECT fileset_id FROM dsFileset WHERE fileset_name = \'$fileset\'" .
+                    " AND prod_id = $prod_id");
 $stmt->execute();
 my $fs = $stmt->fetchrow_hashref();