File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
jsp and mysql error
Joined: Apr 05, 2008
Jul 01, 2008 07:54:00
how to insert a decimal value into mysql database.
eg: value like 2.5 to mysql field of datatype float.
but when i try to insert 2.5 from
to mysql database it get converted to 2 in the database??
[Vipassana] - It is seeing the reality as it is, And not as you want it to be.!!!
Joined: Apr 14, 2004
Jul 01, 2008 09:09:00
How is your float defined? How many digits do you allow after the decimal place?
Joined: Oct 13, 2005
Jul 01, 2008 09:40:00
I think you will have to provide more detail. What format have you got the 2.5 in, and what sort of variable to you put it into, before inserting it into the database?
How did you specify the float value?
Joined: Oct 23, 2005
Jul 01, 2008 13:22:00
Show us the code. I imagine there's somewhere your converting it to integer.
[OCA 8 Book]
It is sorta covered in the
JavaRanch Style Guide
subject: jsp and mysql error
Changing from MSAccess to MySQL
JSF problem with UTF8encoding
how to retive data in struts from database
struts data retrive query.............. important to me
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015