Ignore:
Timestamp:
10/28/10 11:47:07 (14 years ago)
Author:
Daniela Dorner
Message:
bugfix (every run was listed several times)
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Mars/datacenter/scripts/writemcsequencefile

    r10019 r10044  
    6666   
    6767   # data runs
    68    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
     68   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    6969   datruns=`sendquery`
    7070   if [ "$datruns" = "" ]
     
    7474   fi
    7575   # pedestal runs
    76    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
     76   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    7777   pedruns=`sendquery`
    7878   if [ "$pedruns" = "" ]
     
    8282   fi
    8383   # calibration runs
    84    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
     84   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    8585   calruns=`sendquery`
    8686   if [ "$calruns" = "" ]
Note: See TracChangeset for help on using the changeset viewer.