So why not use IS_FLOAT_IN_RANGE()?? requires = IS_FLOAT_IN_RANGE(0, 100, dot=".", error_message='too small or too large!')
Do you really need to specify the value in a dropbox dynamically? If so, requires=IS_IN_SET(SIZES) don't work? Richard On Thu, Feb 13, 2014 at 5:07 PM, greenpoise <danel.sega...@gmail.com> wrote: > A list of decimal values from 0.1 to 50.0 > > > > On Thursday, February 13, 2014 1:47:53 PM UTC-8, Richard wrote: > >> What is SIZES? >> >> Is it a validators? >> >> Richard >> >> >> >> On Thu, Feb 13, 2014 at 4:24 PM, greenpoise <danel....@gmail.com> wrote: >> >>> could it be >>> SIZES = [v*0.05 for v in range(0,int(50/0.05))] >>> >>> which I use to populate a select box? >>> >>> >>> >>> >>> On Thursday, February 13, 2014 1:06:14 PM UTC-8, Richard wrote: >>> >>>> Hmm, the message says Foreign Key constraint... >>>> >>>> Not decimal issue... >>>> >>>> Richard >>>> >>>> >>>> On Thu, Feb 13, 2014 at 4:02 PM, greenpoise <danel....@gmail.com>wrote: >>>> >>>>> For the first time I had to enter a value that was 0.25, for some >>>>> reason, it comes back with this error <class >>>>> 'sqlite3.IntegrityError'> FOREIGN KEY constraint failed >>>>> >>>>> I have the field as a float type. It works with any value except from >>>>> 0.1 to 0.99. I tried decimal (10,3) still nothing. >>>>> >>>>> -- >>>>> 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 web2py+un...@googlegroups.com. >>>>> >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>> >>>> -- >>> 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 web2py+un...@googlegroups.com. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> -- > 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 web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.