The french in the ticket should comes from the ubuntu locales setting, I see
no python packages related to the local...
Richard
On Wed, Nov 17, 2010 at 3:43 PM, Richard Vézina <ml.richard.vez...@gmail.com
> wrote:
> No change with nav set to en-us and with firefox.
>
> Richard
>
>
> On Wed, Nov 17, 2010 at 3:35 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> 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 <mdipie...@cs.depaul.edu>wrote:
>>
>>> could be. Not sure what that means for decimal numbers.
>>>
>>> On Nov 17, 2:07 pm, Richard Vézina <ml.richard.vez...@gmail.com>
>>> 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 <mdipie...@cs.depaul.edu>
>>> 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 <ml.richard.vez...@gmail.com>
>>> > > 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
>>> >
>>> >
>>>
>>
>>
>
