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.
