You need to provide the "scale" attribute (ie Number of decimal places). The
default is zero (0). That is why the value is rounded.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-An
I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted
into the database table. And changed the type in the cfc to cf_sql_decimal.
On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis wrote:
> Something is baffling me.. I'm inserting a value into the database and
> it's rounding
Aha, Google is my friend..
when using cf_sql_decimal you must specify the scale parameter..
scale="2" />
makes it all work.. now to go through and make sure everywhere else I'm
using the cf_sql_decimal I'm providing the scale parameter.
On Mon, Nov 12, 2012 at 11:28 AM, Greg Morphis wrote:
removing the cfqueryparam
,
works..
just having #arguments.payment.getamount_paid()#
causes it to work fine.. 35.52 is saved as 35.52 in the database.
Any ideas as to why this happens? I'm using CF9.0.1
On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis wrote:
> I tried decimal(19,2) and back to
Something is baffling me.. I'm inserting a value into the database and it's
rounding the number. I don't know where or why this is happening!
On the action page this is what the code looks like when inserting
INSERT INTO mytable
5 matches
Mail list logo