Changeset 17315


Ignore:
Timestamp:
11/06/13 12:54:35 (11 years ago)
Author:
Daniela Dorner
Message:
changed column name from fRunId to fRunID
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Mars/fact/analysis/lightcurve.C

    r17104 r17315  
    4848    TString query;
    4949    query=Form("SELECT Min(fNight), Max(fNight) FROM %s ", table.Data());
    50     query+=" LEFT JOIN RunInfo USING(fNight, fRunId) ";
     50    query+=" LEFT JOIN RunInfo USING(fNight, fRunID) ";
    5151    query+=Form(" WHERE fSourceKey=%d", sourcekey);
    5252    if (nightmin)
     
    6060    datacheck+=" AND fNight>20120420 AND NOT fNight IN (20120406,20120410,20120503) AND";//data with different bias voltage
    6161    datacheck+=" NOT fNight BETWEEN 20121206 AND 20130110"; // broken bias channel
    62     //datacheck+=" AND NOT (fNight=20120608 AND fRunId=65) "; // something went wrong with tracking?
     62    //datacheck+=" AND NOT (fNight=20120608 AND fRunID=65) "; // something went wrong with tracking?
    6363    // 24.6. new coefficients
    6464    TString zdparam=" pow(0.753833 * cos(Radians(fZenithDistanceMean)), 7.647435) * exp(-5.753686*pow(Radians(fZenithDistanceMean),2.089609))";
     
    8484
    8585    query =" SELECT fNight FROM "+table;
    86     query+=" LEFT JOIN RunInfo USING(fNight, fRunId) ";
     86    query+=" LEFT JOIN RunInfo USING(fNight, fRunID) ";
    8787    query+=Form(" WHERE fSourceKey=%d", sourcekey);
    8888    query+=Form(" AND fNight BETWEEN %s AND %s ", nightstart.Data(), nightstop.Data());
     
    167167        query+=" fZenithDistanceMax, fZenithDistanceMin, ";
    168168        query+=" fCurrentsMedMeanBeg, fThresholdMinSet FROM "+table;
    169         query+=" LEFT JOIN RunInfo USING(fNight, fRunId) ";
     169        query+=" LEFT JOIN RunInfo USING(fNight, fRunID) ";
    170170        query+=Form(" WHERE fSourceKey=%d", sourcekey);
    171171        query+=Form(" AND fNight= %s ", (*row3)[0]);
     
    176176            query+=datacheck;
    177177
    178         query+=" ORDER BY fRunId ";
     178        query+=" ORDER BY fRunID ";
    179179
    180180        cout << "Q: " << query << endl;
Note: See TracChangeset for help on using the changeset viewer.