Just an update here. I have implemented your solution on my testbed but have not rolled it into the public version yet. In four days I have had four users contact me because "the logon doesn't work". In each case, they had a capital letter somewhere in their email address.
For my fix, I think I would rather let people enter addresses in any case but do the login comparison in a case-insenstitive manner. I did not see UPPER() and LOWER() mentioned in the web2py manual as SQL functions available on columns for queries. I'll look up the source code and see if they're in there. -- Joe B. On Feb 19, 8:47 pm, mdipierro <[email protected]> wrote: > It is intended but can be changed. > > You can do > > db(auth.settigns.table_user.id>0).update > (email=auth.settings.table_user.email.lower()) > > to make all current emails lower case and > > auth.settings.table_user.email.requires=[IS_LOWER(),IS_EMAIL > (),IS_NOT_IN_DB(db,auth.settings.table_user.email)] > > to make sure all new ones are converted lower case upon validation. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
