No change with nav set to en-us and with firefox. Richard
On Wed, Nov 17, 2010 at 3:35 PM, Richard Vézina <[email protected] > wrote: > In the database table decimal are represented like this : 123.123 > > When I export data the "." is replaced by the comma, but I think that > depend of the local of the system or the local I specified in the pgadmin > export panel... > > What the relation between the local of the database and the and the lenght > of the decimal defined in the model? > > I far as I can see web2py return to the database the proper format it > should it only failed to detected the lenght of the entered value. > > Maybe the local of the naviagator is involved?? > > I set chrome to french canada. > > I will make a check in firefox if the problem is not coming from chrome. > > Richard > > > On Wed, Nov 17, 2010 at 3:26 PM, mdipierro <[email protected]>wrote: > >> could be. Not sure what that means for decimal numbers. >> >> 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 >> > >> > >> > >
