Re: Database number

[Campano, Troy]

have you tried printing out your INSERT statement to the JSP page and then copy/paste it into SQLPLUS to run the SQL against just the database.

If you do that then it would be easier to figure out if it's a database issue or Java issue.

 

thanks!

 

 

Troy Campano

 

[:==> Troy Campano <==:] - Roadwarrior on the Information Superhighway
Request Manager/Database/Web
Microsoft gave you Windows, UNIX the whole house.

-----Original Message-----
From: srinivas tadikonda [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 10:15 AM
To: [EMAIL PROTECTED]
Subject: Database number

Hi,

 

   Please help me the following situation.

 

   I am tring to insert some data into oracle database. Here one field datatype is

Number(22,6)

what ever I inserted in this field it will take only (after decimal) two degits.  Actually I want to to be inseterd after decimal 6digits.  How can I solve this. 

ex:  if I insert :   34567.58587 .

Database shows : 34567.59 but I want exactly what I inserted.

Please help me.

Regards

Srinivas

 

---

Get your FREE download of MSN Explorer at http://explorer.msn.com
=========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com