Data problem

Aaron Bingham bingham at cenix-bioscience.com
Wed Dec 15 17:33:22 CET 2004


Jeffrey Maitland wrote:
> 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
--------------------------------------------------------------------




More information about the Python-list mailing list