Re: users change an email address

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43958
interpreted = N
texte = Doesn't that mean that in your search, you'll have to add a 'not include' current record... neuniqueIDdatarq=[uniqueID][search db=members.db&neuniqueIDdatarq=[uniqueID]&eqEMAILdata=[url][uppercase][email ][/uppercase][/url]] -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Lester Emo > Reply-To: (WebCatalog Talk) > Date: Tue, 01 Oct 2002 21:03:21 > To: (WebCatalog Talk) > Subject: Re: users change an email address > > Nope. Didn't work . . . > even tried it with eqEMAILdatarq > I had tried a similar search earlier as well > > In my scenario: > A user has an email like emo@emo.com > > A 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][/u r>> l >>> ]&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/ > ------------------------------------------------------------- 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)
Doesn't that mean that in your search, you'll have to add a 'not include' current record... neuniqueIDdatarq=[uniqueID][search db=members.db&neuniqueIDdatarq=[uniqueID]&eqEMAILdata=[url][uppercase][email ][/uppercase][/url]] -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Lester Emo > Reply-To: (WebCatalog Talk) > Date: Tue, 01 Oct 2002 21:03:21 > To: (WebCatalog Talk) > Subject: Re: users change an email address > > Nope. Didn't work . . . > even tried it with eqEMAILdatarq > I had tried a similar search earlier as well > > In my scenario: > A user has an email like emo@emo.com > > A 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][/u r>> l >>> ]&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/ > ------------------------------------------------------------- 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/ Tim Robinson

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 1.6 and SHTML (1997) Hiding usernames and passwords in URL (1998) osx or redhat and / or other (2005) [/application] error? (1997) Nested tags count question (1997) Sorting a [listfiles] (2003) can you take a look (2003) Re1000001: Setting up shop (1997) AppleScript question (1997) RAM variables (1997) Problems with [Applescript] (1997) Needed, Freelance Web Developer (2007) [numfound] in nested [search] (2000) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebDNA 5.0 and Mac OS/9 ... The facts (2003) Dual processors? (2000) Shopping Cart variation... (1997) Banners (1997) Re:2nd WebCatalog2 Feature Request (1996) QuitFeedback & DBNotOpened errors (1997)