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.