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 <gmorp...@gmail.com> wrote: > 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 > ( > af_id, > amount_paid, > is_cleared, > payment_method_id, > action_date, > year_paid_for, > notes, > actionuser > ) > VALUES > ( > ?, > ?, > ?, > ?, > ?, > ?, > ?, > ? > ) > > > Query Parameter Value(s) - > Parameter #1(cf_sql_integer) = 194 > *Parameter #2(cf_sql_numeric) = 35.52* > Parameter #3(cf_sql_integer) = 1 > Parameter #4(cf_sql_integer) = 1 > Parameter #5(cf_sql_timestamp) = 2012-11-12 10:51:54.375 > Parameter #6(cf_sql_integer) = 2012 > Parameter #7(cf_sql_varchar) = > Parameter #8(cf_sql_numeric) = 12985 > > > > When I query the database I see 36.00 > The table column use to be smallmoney, now it's numeric(19,2).. > Does anyone know why this might be happening? And more importantly, how to > fix it!? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm