Hi Annet
I appreciate the quick response.
I changed the table definition to include:
Field('payment_amount', type='decimal(10,2)',
label=T('Payment Amount'),
requires=IS_DECIMAL_IN_RANGE(-1e100, 1e100, dot=".")),
Entering an amount of say '1,000' now traps the error at the form
validation stage, which is much better. However, it would be better still
if the '1,000' could be changed to '1000' in the background - any ideas?
Thanks for the help,
Andy
On Wednesday, April 22, 2015 at 10:18:18 AM UTC+4, Annet wrote:
>
> Hi Andy,
>
> Use the IS_DECIMAL_IN_RANGE() validator
>
> db.receipt.payment_amount.requires=IS_DECIMAL_IN_RANGE(-1e100, 1e100,
> dot=".")
>
>
> From the web2py book:
>
> The minimum and maximum limits can be None, meaning no lower or upper
> limit, respectively.
>
> The dot argument is optional and allows you to internationalize the
> symbol used to separate the decimals.
>
> Kind regards,
>
> Annet
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
