Problem with round number in field

Questions › Problem with round number in field
0 Vote Up Vote Down
Eduardo asked 11 years ago

Hi. I'm having a problem with a field in the grid. If i try to put a number for example "12.32" it doesn't show but rounded "12". Is there a predefined setup that make that happen? i like that number show its deciamals, i tried with $col["formatter"] = "number"; and it shows 2 decimals "12,00" but still not the amount i want. What can i do?

2 Answers
0 Vote Up Vote Down
Abu Ghufran answered 11 years ago

Please make sure your database table have field type that support decimal.
I've tested the case, it may be truncated at database level at your end.

0 Vote Up Vote Down
Eduardo answered 11 years ago

Oh, my bad. Thank you. It was the database field type that was int, i changed it to decimal and problem solved. Thank you for helping me.

Your Answer

10 + 6 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.


How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?