Hi Djam, I guess this solves the issue - this is precisely what the brat code is doing flemming ---------------------------------------------------------------- Flemming Videbaek Physics Department Brookhaven National Laboratory e-mail: videbaek@bnl.gov phone: 631-344-4106 ----- Original Message ----- From: "Djamel Ouerdane" <ouerdane@nbi.dk> To: "Brahms Devel List" <brahms-dev-l@lists.bnl.gov> Sent: Wednesday, April 28, 2004 10:01 AM Subject: [Brahms-dev-l] subtle mysql feature > Hello, > > Truls was really puzzled about the fact that the calibration value he > committed today (drift velocity) did not show up in the table generated by > the calibration perl script, it was still the old value. After a couple of > tries, I put my hands into the guts of mysql queries and found out that > there were 4 revisions of the drift velocity corresponding to the same > validStart time. In the perl script, I modified the query form as follows: > > ORDER BY date DESC > > With this, it picks up the very latest revision. It also solves the > mystery about drift velocities * 1000. > > Sorry for the little panic... ;) > > Ciao > Djam > > > > -- > Djamel Ouerdane ------------------------------------------o > | Niels Bohr Institute | Home: | > | Blegdamsvej 17, DK-2100 Ø | Jagtvej 141 2D, | > | Fax: +45 35 32 50 16 | DK-2200 Copenhagen N | > | Tel: +45 35 32 52 69 | +45 35 86 19 74 | > | http://www.nbi.dk/~ouerdane | > | ouerdane@nbi.dk | > o---------------------------------------------------------o > > _______________________________________________ > Brahms-dev-l mailing list > Brahms-dev-l@lists.bnl.gov > http://lists.bnl.gov/mailman/listinfo/brahms-dev-l > _______________________________________________ Brahms-dev-l mailing list Brahms-dev-l@lists.bnl.gov http://lists.bnl.gov/mailman/listinfo/brahms-dev-lReceived on Wed Apr 28 10:04:22 2004
This archive was generated by hypermail 2.1.8 : Wed Apr 28 2004 - 10:04:32 EDT