If we were to do it I would have gone for (-99.99,+99.99)
On Nov 18, 10:50 am, Richard Vézina <[email protected]> wrote: > Ok... I could set it to : (0,00.99) for example. > > Thanks! > > Richard > > On Wed, Nov 17, 2010 at 6:00 PM, mdipierro <[email protected]> wrote: > > 4,2 have to do with precision, not range. > > > On Nov 17, 4:18 pm, Richard Vézina <[email protected]> > > wrote: > > > Ok, > > > > I think I wrongly define the IS_DECIMAL_IN_RANGE > > > > I set it to (0,99.99) > > > > And now the validators works. > > > > Still wondering if IS_DECIMAL_IN_RANGE as to be explicitly define since > > the > > > decimal(4,2) were already available???? > > > > Richard > > > > On Wed, Nov 17, 2010 at 4:06 PM, Richard Vézina < > > [email protected] > > > > > wrote: > > > > Just to be sure... Data are entered in english... Mean if we entered > > > > exactly this in the form fiel : 123.123 > > > > > On Wed, Nov 17, 2010 at 3:59 PM, Jonathan Lundell <[email protected] > > >wrote: > > > > >> On Nov 17, 2010, at 12:26 PM, mdipierro wrote: > > > > >> > could be. Not sure what that means for decimal numbers. > > > > >> FWIW, I took a look at the Python decimal module, and it requires '.' > > as > > > >> the decimal separator. So any conversion is going to have to happen > > before > > > >> Decimal gets the string. > > > > >> > On Nov 17, 2:07 pm, Richard Vézina <[email protected]> > > > >> > wrote: > > > >> >> I use postgresql and local in postgres are : fr_CA.UTF-8 > > > > >> >> Could it be the reason of the problem? > > > > >> >> Richard > > > > >> >> On Wed, Nov 17, 2010 at 2:37 PM, mdipierro < > > [email protected]> > > > >> wrote: > > > >> >>> BTW... why are you getting the traceback in french? If your python > > is > > > >> >>> localized, could this affect the meaning of . in sqlite? > > > > >> >>> On Nov 17, 9:43 am, Richard Vézina <[email protected]> > > > >> >>> wrote: > > > >> >>>> Hello, > > > > >> >>>> I wonder if it is normal that I get ticket in that case : > > > > >> >>>> Model : > > > > >> >>>> Field('field1','decimal(4,2)'), > > > > >> >>>> If I insert in form generate with crud.create(db.table1) this > > value : > > > >> >>>> 123.123 > > > > >> >>>> I get ticket : > > > > >> >>>> Error traceback > > > > >> >>>> 1. > > > >> >>>> 2. > > > >> >>>> 3. > > > >> >>>> 4. > > > >> >>>> 5. > > > >> >>>> 6. > > > >> >>>> 7. > > > >> >>>> 8. > > > >> >>>> 9. > > > >> >>>> 10. > > > >> >>>> 11. > > > >> >>>> 12. > > > >> >>>> 13. > > > >> >>>> 14. > > > >> >>>> 15. > > > >> >>>> 16. > > > >> >>>> 17. > > > >> >>>> 18. > > > >> >>>> 19. > > > >> >>>> 20. > > > >> >>>> 21. > > > > >> >>>> Traceback (most recent call last): > > > >> >>>> File "/web2py/gluon/restricted.py", line 188, in restricted > > > >> >>>> exec ccode in environment > > > >> >>>> File "/web2py/applications/app/controllers/test.py", line 552, > > in > > > >> >>> <module> > > > >> >>>> File "/web2py/gluon/globals.py", line 96, in <lambda> > > > >> >>>> self._caller = lambda f: f() > > > >> >>>> File "/web2py/gluon/tools.py", line 2270, in f > > > >> >>>> return action(*a, **b) > > > >> >>>> File "/web2py/applications/app/controllers/test.py", line 372, > > in > > > >> >>> update > > > >> >>>> if form.accepts(request.vars, session): > > > >> >>>> File "/web2py/gluon/sqlhtml.py", line 1144, in accepts > > > >> >>>> self.table._db(self.table.id == self.record.id > > ).update(**fields) > > > >> >>>> File "/web2py/gluon/sql.py", line 3484, in update > > > >> >>>> self._db._execute(query) > > > >> >>>> File "/web2py/gluon/sql.py", line 1026, in <lambda> > > > >> >>>> self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > > > >> >>>> DataError: ERREUR: champ numérique en dehors des limites > > > >> >>>> DETAIL: Un champ de précision 4 et d'échelle 2 doit être arrondi > > à > > > >> une > > > >> >>> valeur > > > >> >>>> absolue inférieure à 10^2. > > > > >> >>>> I thought that the validator will show up a error... > > > > >> >>>> Do I have to use IS_DECIMAL_IN_RANGE and why since I precised the > > > >> decimal > > > >> >>>> limit in the model??? > > > > >> >>>> Regards. > > > > >> >>>> Richard > >
