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:

limitation found on group searching (1997) Searching Dates (2000) proper way to check if a container is empty? (2000) SFTP (2004) WebDNA Solutions ... sorry! (1997) [OT] (waaaay OT) (2004) Sitebuilder (2004) spawn (1998) Problems getting parameters passed into email. (1997) WebCat2: Found Items syntax, etc. (1997) WebCat2b13 Command Reference Doc error (1997) different show next (1997) HELP WITH DATES (1997) WebCat2.0 [format thousands .0f] no go (1997) User Authentication (2003) problems with 2 tags (1997) Re1000001: Setting up shop (1997) [WebDNA] El Capitan (2017) Help! WebCat2 bug (1997) Using Plug-In while running 1.6.1 (1997)