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:

[WebDNA] Emailer Issue (2009) Configuring E-mail (1997) Protecting webdelivery (1997) Prevent multiple appends with Reload Button (1997) do you have a webcatalog tool you want to sell? (1999) Multiple download orders of the same product? (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) More on the email templates (1997) [WebDNA] search by range of dates (2009) CGI Request Time Out (1997) FW: Shipping calculations (1997) Width & Height (1998) searching problem (1998) 3.08 has trouble keeping the serial # ?? (2000) WCf2 and nested tags (1997) no global [username] or [password] displayed ... (1997) WC2b15 File Corruption (1997) [WebDNA] Testing (2016) [WebDNA] Fails to recognize comma-separated db (2010) japanese characters (1997)