I think I'm having the same problem. All of my prices are decimal(9,2) but
they are printing 4 decimal places:
https://pricetack.com/item/test-868
On my Mac with SQLite, they are printing OK with 2 places.
On production, I'm using Postgres but a checked the DB and it's only
storing two places.
I didn't see anything in my validators or elsewhere.
On Saturday, November 29, 2014 at 8:58:56 AM UTC-8, Tom Øyvind Hogstad
wrote:
>
> I have the following field declaration
>
> Field('test_BOF', 'decimal(10,2)',
> label='BOF (mg/l)',
> requires=IS_EMPTY_OR(IS_DECIMAL_IN_RANGE(dot=','))
>
> In a SQLFORM this vil output as a number with a for numbered fraction e.g.
> 12,3000
>
> <input class="decimal" id="plant_service_test_BOF" name="test_BOF" type=
> "text" value="12,3000">
>
> How can i format this value?
>
> Web2Py: 2.9.11
> DB: PostgreSQL 9.3
>
> Tom Ø.
>
>
> (BTW maybe w2p should detect the requested number of decimals from the field
> type in this case?)
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
