Hi,
I am using Java to maintain a MySQL database. I have a table in the
database created by:
CREATE TABLE track_char (
+ id INT UNSIGNED NOT NULL AUTO_INCREMENT,
+ PRIMARY KEY (id),
+ name CHAR(40),
+ posX
[snip]
Now, when I try to update the rotX, rotY, and rotZ fields, I have to put
a double into it, ints don't work. But then, when I print out the
database, it looks like this:
Which clearly indicates that it is storing the rot fields as ints.
I am just wondering why I can't give it an
Subject: RE: INT wants a float/double?
[snip]
Now, when I try to update the rotX, rotY, and rotZ fields, I have to put
a double into it, ints don't work. But then, when I print out the
database, it looks like this:
Which clearly indicates that it is storing the rot fields as ints.
I
[snip]
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
[/snip]
Do a describe on the table and make sure that they are INTs, then show
us the update statement.
because it is hard to read
why?
top
() method by using hard-coded values...only
hard-coded doubles work, hard-coded ints wouldn't.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:09 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject: RE: INT wants a float/double?
[snip]
Right
[snip]
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI
: RE: INT wants a float/double?
[snip]
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id
[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:
: 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