I am using the MySQLdb module and I am writing to a MySQL database.
My write statement is something like.
cursor.execute(“INSERT INTO Data(Name, X, Y, Z, Data)
VALUES('%s', '%s', '%s', '%f', '%f', '%f', '%s')""" %
(name, high_x, high_y, high_z, data))
This is not causing your problem, but why not take advantage of the DB-API value substitution support, e.g.:
cursor.execute("""INSERT INTO Data(Name, X, Y, Z, Data) VALUES(%s, %f, %f, %f, %s)""",
(name, high_x, high_y, high_z, data))This will take care of correctly escaping and quoting strings and formatting floats for you automatically.
I can write the data to a file as a check and all variables are showing correctly. However when I extract the data from the database the X, Y are not coming out with the same number that “should be going” into the database but the Z is. Any Ideas?
My first guess would be that the X and Y fields in the DB are actually defined as integers, not floats, but you probably already checked that.
Regards,
-- -------------------------------------------------------------------- Aaron Bingham Application Developer Cenix BioScience GmbH --------------------------------------------------------------------
-- http://mail.python.org/mailman/listinfo/python-list
