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 <ml.richard.vez...@gmail.com
> 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 <jlund...@pobox.com>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 <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
>> >>
>> >>
>>
>>
>>
>
