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:

[WriteFile] problems (1997) All choices on IE different than Netscape (1997) spell check site (2005) lookups or math? (1998) Custom Shipping Charges (1997) Date problems (1997) Why this code works from some places and doesn't from others? (2000) WebCatalog 4.0.2b5 available (2000) Random Image (1998) Practice runs ? (1997) W* 3.x & WebCat + WebMerchant (1998) Hideif on IP range (2004) MacAuthorize hub, no modal password dialog? (1997) fresh eyes needed. Append won't work. (2000) Web Catalog 2 demo (1997) lookup problem (2000) Frames and WebCat (1997) [WebDNA] [AddFields] Restrictions (2012) problems with 2 tags (1997) emailer stuck (1997)