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. Thanks, Jams
"jamuna", 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 http://www.javaranch.com/name.jsp . 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.