Re: users change an email address

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43956
interpreted = N
texte = Nope. Didn't work . . . even tried it with eqEMAILdatarq I had tried a similar search earlier as wellIn my scenario: A user has an email like emo@emo.comA 2nd user logs in, and can change his email to be emo@emo.com Not a good thing . . .Preventing that is what I'm trying to do. At 01:55 PM 10/2/02, you wrote: >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/ ------------------------------------------------------------- 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:

    
  1. Re: users change an email address (Lester Emo 2002)
  2. Re: users change an email address (Tim Robinson 2002)
  3. Re: users change an email address (Alain Russell 2002)
  4. Re: users change an email address (Lester Emo 2002)
  5. Re: users change an email address (Tim Robinson 2002)
  6. Re: users change an email address (Alain Russell 2002)
  7. Re: users change an email address (Lester Emo 2002)
  8. Re: users change an email address (Alain Russell 2002)
  9. users change an email address (Lester Emo 2002)
Nope. Didn't work . . . even tried it with eqEMAILdatarq I had tried a similar search earlier as wellIn my scenario: A user has an email like emo@emo.comA 2nd user logs in, and can change his email to be emo@emo.com Not a good thing . . .Preventing that is what I'm trying to do. At 01:55 PM 10/2/02, you wrote: >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/ ------------------------------------------------------------- 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

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

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...

Related Readings:

Why do extra quotation marks sometimes appear in my databases? (1998) OT: Merchant Accounts (2003) Nested search (1997) Re:Emailer and encryption (1997) email code (1998) Webcatalog error, Plug-in for Webstar (1996) [OT] Certs (2002) syntax question, not in online refernce (1997) No shipping systems available? (1998) .eml files (2001) WebCat2 Append problem (B14Macacgi) (1997) carriage returns in data (1997) Emailer setup (1997) Not really WebCat (1997) Search in 2 or more catalogs (1997) Changing SubTotal (2003) WebStar Secure on other machine (1997) Preferred Web Design Tool? (1999) Error Page? (1997) Running 2 two WebCatalog.acgi's (1996)