numero = 43954
interpreted = N
texte = I have users create a profile before they can make posts in a message board. I want to allow a user to update their email address. BUT I want to prevent them from having multiple usernames with the same email address.I prevent this from happening at the create a username stage, but when I try to change the email address to another one, or make other changes to the profile leaving the email as is, I keep running into a Email in use error and can't seem to get around it. In my edit_profile.tpl page I have the followingEmail: In my profile_replace.tpl I have the following[showif [email]=[lookup db=members.db&lookinField=email&value=[url][uppercase][email][/uppercase][/url]&returnField=email¬Found=NotFound]] Error! That Email Address has been used already to register a username Multiple usernames with the same email address are not allowed[/showif]I've tried variations with [search] as well, all with the same result.I don't want to have an error appear if the email is NOT changed, which it does now, only if a user tries to add an email address that already is in the database with another username.My database fields in my members.db are:uniqueID user pass groups secretword email signupdate signuptime ipaddress Any thoughts on how I'd prevent the same email address from being used a 2nd time by a user? Thanks lester ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I have users create a profile before they can make posts in a message board. I want to allow a user to update their email address. BUT I want to prevent them from having multiple usernames with the same email address.I prevent this from happening at the create a username stage, but when I try to change the email address to another one, or make other changes to the profile leaving the email as is, I keep running into a Email in use error and can't seem to get around it. In my edit_profile.tpl page I have the followingEmail: [lowercase][email][/lowercase]>In my profile_replace.tpl I have the following[showif [email]=[lookup db=members.db&lookinField=email&value=[url][uppercase][email][/uppercase][/url]&returnField=email¬Found=NotFound]] Error! That Email Address has been used already to register a username Multiple usernames with the same email address are not allowed[/showif]I've tried variations with [search] as well, all with the same result.I don't want to have an error appear if the email is NOT changed, which it does now, only if a user tries to add an email address that already is in the database with another username.My database fields in my members.db are:uniqueID user pass groups secretword email signupdate signuptime ipaddress Any thoughts on how I'd prevent the same email address from being used a 2nd time by a user? Thanks lester ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Lester Emo
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...