I use represent to prevent this kind of stuff...
represent=lambda value, row: '{0:.1f}'.format(value) if value is not None
else T('N/A')),
With microformat language provide by .format()
It allows me to also, extend my field domain (more places) and keep the
display unchanged at webapp level...
Richard
On Thu, Feb 5, 2015 at 12:36 AM, pbreit <pbreitenb...@gmail.com> wrote:
> And when number is ##.00 it's dropping off the decimals entirely:
> https://pricetack.com/item/new-livescribe-echo-4gb-smartpen-73
>
>
>
> On Wednesday, February 4, 2015 at 9:19:08 PM UTC-8, pbreit wrote:
>>
>> 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
>> <https://www.google.com/url?q=https%3A%2F%2Fpricetack.com%2Fitem%2Ftest-868&sa=D&sntz=1&usg=AFQjCNEyAWCCT3OWPpY3znTpxV81Cs4Mng>
>>
>> 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.
>
--
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.
