But your field is decimal type right?
So I guess you should use decimal in your SIZES calculation...
Something like this :
from deciaml import *
[v*Decimal('0.05') for v in range(0,int(50/Decimal('0.05')))]
Richard
On Fri, Feb 14, 2014 at 3:43 PM, greenpoise <danel.sega...@gmail.com> wrote:
> requires=IS_IN_SET(SIZES)
>
> is what I am using but fails to accept values under 1.0. So, 0.1 to 0.99
> prompt the error
>
>
>
>
>
> On Thursday, February 13, 2014 6:48:01 PM UTC-8, Richard 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....@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+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.
