Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 60847 invoked from network); 13 Dec 2006 22:38:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Dec 2006 22:38:43 -0000 Received: (qmail 51007 invoked by uid 500); 13 Dec 2006 22:38:50 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 50995 invoked by uid 500); 13 Dec 2006 22:38:50 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 50984 invoked by uid 99); 13 Dec 2006 22:38:50 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 14:38:50 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [66.174.76.156] (HELO njbrsmtp2.vzwmail.net) (66.174.76.156) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 14:38:39 -0800 Received: from [10.0.1.6] (smtp.vzwmail.net [66.174.76.25]) (authenticated bits=0) by njbrsmtp2.vzwmail.net (8.12.9/8.12.9) with ESMTP id kBDMcBMK014732 for ; Wed, 13 Dec 2006 22:38:17 GMT Mime-Version: 1.0 (Apple Message framework v752.3) Content-Transfer-Encoding: 7bit Message-Id: <077588F8-B719-4B53-9F64-569FB901C01A@internection.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: Apache Torque Users List From: Jon August Subject: BigDecimal and MySQL decimal Date: Wed, 13 Dec 2006 17:38:07 -0500 X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org Hey, I'm using decimal (in the schema) to store a dollar amount in my MySQL database. I get the value from a web page and convert it to a BigDecimal before storing it. For some reason, the decimal portion gets truncated and $10.32 gets stored as 10. Should I be using something other than BigDecimal or is there something else wrong? Sorry if this is not a torque question. -Jon --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org