Changeset 10044


Ignore:
Timestamp:
Oct 28, 2010, 11:47:07 AM (10 years ago)
Author:
dorner
Message:
bugfix (every run was listed several times)
Location:
trunk/Mars
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/Mars/Changelog

    r10043 r10044  
    1818
    1919                                                 -*-*- END OF LINE -*-*-
     20
     21 2010/10/28 Daniela Dorner
     22
     23   * datacenter/scripts/writemcsequencefile:
     24     - bug fix (every run was listed several times)
     25
     26
    2027
    2128 2010/10/27 Daniela Dorner
  • 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.