We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Disable rounding in CFGRID

Medium Priority
854 Views
Last Modified: 2012-06-22
I am using a cfgrid to edit pricing that goes down the three decimal places, such as 0.315 but cfgrid keeps rounding them up to the nearest 2nd decimal, such as 0.32 for the number above. Is there a way to disable the round in cfgrid?
Comment
Watch Question

Author

Commented:
I have also tried numberformat="9.999" on the column.
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
What version of CF and where is the rounding occurring (view, on edit, on submit)?

Author

Commented:
CF9 and after I do an edit.
CERTIFIED EXPERT
Most Valuable Expert 2015
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
That worked when I typed it in and then click on another cell, it didn't round it up but when if I hit the update button it still rounds it up. My apologies if I didn't give the correct problem last night, long day.

Author

Commented:
My fault, I had the update script as

cfsqltype="cf_sql_decimal" scale="2"

when it should have been:

cfsqltype="cf_sql_decimal" scale="3"

Works perfectly now. Thank you very much.
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
Welcome :)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.