numero = 43955
interpreted = N
texte = You will need to change the lookup to be somehting like ..[search db=members.db&eqEMAILdata=[url][uppercase][email][/uppercase][/url]] [showif [numfound]=0] we found the address - do somestuff [/showif] [hideif [numfound]=0] we didn't find it - go ahead [/hideif] [/search] > 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 following > > Email: > value=[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/ ------------------------------------------------------------- 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:
You will need to change the lookup to be somehting like ..[search db=members.db&eqEMAILdata=[url][uppercase][email][/uppercase][/url]] [showif [numfound]=0] we found the address - do somestuff [/showif] [hideif [numfound]=0] we didn't find it - go ahead [/hideif] [/search] > 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 following > > Email: > value=[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/ ------------------------------------------------------------- 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/
Alain Russell
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...