File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes FORM DATA RETREIVAL...................URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "FORM DATA RETREIVAL...................URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!" Watch "FORM DATA RETREIVAL...................URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!" New topic

FORM DATA RETREIVAL...................URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!


Joined: Feb 16, 2001
Posts: 8
I'm trying to retreive data from a table.the column type is decimal(8,2).it's an amount and I've inserted a value 123.45 in the table.when I try to retreive this value in the servlet and display using rs.getDouble("amount") it shows as 12345.0 .I'm using the mysql database.Could you please help me in fixing this problem.
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
We all like to help as much as we can, here, but you really have to help if you expect to get a sensible answer.
1. The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements.
2. Please don't post the same message to more than one forum. You obviously read more than one, and so do the people who might know the answer. If you annoy people they are a lot less likely to answer you. This is really a database question, so it should only be in the JDBC forum.
3. It has been shown here many times that putting URGENT on a post only serves to prevent people from answering. Everyone here is an unpaid volunteer, with limited time to spend on answering questions. We first answer the ones which are polite, well thought out, clearly expressed, and show that the poster has done some research of his/her own before asking. Only after we have helped the polite people, and the people who also try to help others, do we get to posts like this.
The more you can help someone to answer your question, the more likely you are to get a useful answer.


Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
It is sorta covered in the JavaRanch Style Guide.
subject: FORM DATA RETREIVAL...................URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!
jQuery in Action, 3rd edition