[Brahms-dev-l] subtle mysql feature

From: Djamel Ouerdane <ouerdane@nbi.dk>
Date: Wed Apr 28 2004 - 10:01:17 EDT
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
Received on Wed Apr 28 10:01:43 2004

This archive was generated by hypermail 2.1.8 : Wed Apr 28 2004 - 10:02:11 EDT