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:

WebMerchant? (1998) Maybe Off Topic -- OS X/UNIX Shell Scripts? (2003) [SearchString] usage (1997) Encyption mail (1998) Re:WebCatalog f2 Installation (1997) Automatic Download? (2003) WebCat2b12 - nesting [tags] (1997) Odd Cart Behavior (1997) BBEdit and WebCatalog 2.0? (1997) WebCatalog for Mac 2.0.1 Released (1997) Which [index]? (1997) syntax question, not in online refernce (1997) [protect] on NT? (1997) [isfile] ? (1997) Friendly , quick 'security' check, please (2003) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) [WebDNA] email stops sending (2008) Summing fields (1997) Setting up WebCatalog with Retail Pro data (1996) Claris HomePage messes up the code (1997)