Data problem
Jeffrey Maitland
maitj at vianet.ca
Wed Dec 15 10:28:24 EST 2004
Hello all,
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))
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?
Example data going in and out.
IN.
Name = test
X = 34.523
Y = -123.2432
Z = -123.2346
Data = "This is test data"
OUT
Name = test
X = 34.0
Y = -123.0
Z = -123.2346
Data = "This is test data"
That's is what is going in and coming out.
*Note this is an example of the data not actual data or code (Although
the difference is the amount of data being input)"
Thanks for any and all help/comments.
Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20041215/1e7c2899/attachment.html>
More information about the Python-list
mailing list