Did you convert current emails in lower case?
db(auth.settigns.table_user.id>0).update
(email=auth.settings.table_user.email.lower())
db.commit()
On Feb 23, 3:37 pm, Joe Barnhart <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
