[web2py] Re: unique field with case insensitivity

2012-06-23 Thread Corey Marques
is going to be "filled" (updated, or > inserted) by web2py, you can apply a custom validator: only data inserted > or updated from within web2py will be "checked" > > On Saturday, June 23, 2012 3:29:48 AM UTC+2, Corey Marques wrote: >> >> OK, ma

[web2py] Re: unique field with case insensitivity

2012-06-22 Thread Corey Marques
OK, maybe this is a better question. How to I specify that the column is NOCASE using the DAL? On Wednesday, June 20, 2012 4:33:55 PM UTC-4, Corey Marques wrote: > > Howdy, > > I'm trying to put together a quick proof of concept to use this framework > for porting our de

[web2py] unique field with case insensitivity

2012-06-20 Thread Corey Marques
Howdy, I'm trying to put together a quick proof of concept to use this framework for porting our desktop application to the web. I ran into an issue where unique fields don't follow our rules. In our database the 'nickname' field is unique and "JOE" is the same as "joe". I did a quick search a