gave a look at your code, (sorry so long passed) and I found that you have forgotten the comma, that is why the program complains.
std::string bindinsert("INSERT INTO DCOPS_NEW_DCOPS (DLC_index
DCOPS_index Laser_index status mean_1 mean_2 mean_3 mean_4 merr_1
merr_2 merr_3 merr_4 sigma_1 sigma_2 sigma_3 sigma_4 asig_1 asig_2
asig_3 asig_4 aback_1 aback_2 aback_3 aback_4 chi_1 chi_2 chi_3 chi_4
ndof_1 ndof_2 ndof_3 ndof_4 Line_timestamp Temperature) VALUES(:1 :2
:3 :4 :5 :6 : ....
should be rather:
std::string bindinsert("INSERT INTO DCOPS_NEW_DCOPS (DLC_index,
DCOPS_index, Laser_index,... ) VALUES(:1, :2, :3, :4, :5, :6 :, ....
with the comma in both the list of variable names and list of bind variables.
try again please and let me know,
(By the way, do you have a test DB account to test your program? )
cheers, Francesca
I take a single SLM: ME+3/2, for example, and use Jim's chamber positions. I predict where these will be along the ideal SLM on the ideal YE+2 position. Then, using the DCOPS positions from the DDDMEp23.sdf file, I predict where the DCOPS centers will be in the U/D coordinate: perpendicular to the SLM and within the plane of the ring. On this I plot the positions of the profiles relative to the center for each laser.
The result, as you can easily see above, does not look particularly good. Either the DCOPS positions relative to the chambers are seriously wrong, or the input chamber positions are wrong, since the profile positions do not line up.
The transfer plate positions along the SLM are not symmetric. This is because this uses position 5 at ME3, which had to be mirrored into a different location because of space constraints.
Modified 03-November-2010 at 10:17
http://hep.physics.wisc.edu/~jnb/cms/03Nov2010
| Previous notes | Next notes | Main slide directory |