Exactly. If you do not set the scale it rounds a decimal to the integer value.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Monday, February 20, 2006 4:17 PM To: [email protected] Subject: RE: Reactor For CF Numeric datatype problems Why would I need the precision? Is that the scale attribute on the cfqueryparam tag? Ugh. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Corfield Sent: Wednesday, February 08, 2006 8:14 PM To: [email protected] Subject: Re: Reactor For CF Numeric datatype problems On 2/8/06, Michael Lantz <[EMAIL PROTECTED]> wrote: > So, I am working on a project that includes the use of a Decimal datatype. > > When I look at the values in SQL Server Management Studio, the values > look fine, but when they are inside a Reactor object, the value gets > truncated to > an integer. The length metadata field is, by definition, an integer. It appears that Reactor needs to add an additional metadata field for precision or something similar (and update the ObjectDao CFCs for each database). -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ **************************************************************************** This email may contain confidential material. If you were not an intended recipient, Please notify the sender and delete all copies. We may monitor email to and from our network. **************************************************************************** -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
