It does. Thanks a lot.
On Monday, September 23, 2013 7:52:40 PM UTC+3, Massimo Di Pierro wrote:
>
> It will not work for data already stored in mixed case. It should work for
> newly created records. Does it not?
>
> On Sunday, 22 September 2013 16:50:11 UTC-5, Avi A wrote:
>>
>> This doesn't seem to work:
>> db.define_table('t_categories',
>> Field('f_category_name', type='string', notnull=True,
>> label=T('Category Name')),
>> auth.signature,
>> format='%(f_category_name)s',
>> migrate=settings.migrate)
>> db.define_table('t_categories_archive',db.t_categories,Field('current_record','reference
>>
>> t_categories',readable=False,writable=False))
>> db.t_categories.f_category_name.requires=(IS_LOWER(),
>> IS_NOT_IN_DB(db,'t_categories.f_category_name'))
>>
>> Still one and One are different.
>>
>> On Monday, September 23, 2013 12:29:24 AM UTC+3, Avi A wrote:
>>>
>>> Thank you very much :).
>>>
>>> On Monday, September 23, 2013 12:23:20 AM UTC+3, Massimo Di Pierro wrote:
>>>>
>>>> You can do:
>>>>
>>>> requires=(IS_LOWER(), IS_NOT_IN_DB(db,'tablename.fieldname'))
>>>>
>>>> So they are always converted in lower case before checking.
>>>>
>>>>
>>>> On Sunday, 22 September 2013 16:14:15 UTC-5, Avi A wrote:
>>>>>
>>>>> Hi,
>>>>> 'unique=True' works but 'one' is different from 'One' for the
>>>>> validator. What should I add to prevent it?
>>>>> Thanks.
>>>>>
>>>>>
>>>>>
--
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.
