Though what I still don't understand is why your error message talk about FK issue...
It's like you have a missmatch in field declaration in your model... Richard On Thu, Feb 13, 2014 at 9:48 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > 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.