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.