Ahhh! I should have thought of this beforehand. The query I was sending using doubles: UPDATE track_char SET rotX = 0.0, rotY = 0.0, rotZ = 0.0WHERE name = 'Tom'
The query I was sending using ints: UPDATE track_char SET rotX = 0, rotY = 0, rotZ = 0WHERE name = 'Tom' There was a missing space between the value for rotZ and the 'WHERE'. I guess when I used a double, it just ignored that and accepted the syntax. Well, thanks for advising me to do the obvious, I now have this working exactly the way it should be! -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 2:38 PM To: Thomas Amundsen; mysql@lists.mysql.com Subject: RE: INT wants a float/double? [snip] It seems to work with INTs when I do it from the MySQL commandline. I guess something is weird with the JDBC connector or something... [/snip] May I suggest echoing your query out so that you can see what it is trying to insert? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
