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:353130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
