Re: users change an email address

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43961
interpreted = N
texte = Yes. Beautiful sun, bluest sky you've ever seen..... ;-) -- 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: Alain Russell > Reply-To: (WebCatalog Talk) > Date: Wed, 02 Oct 2002 14:31:53 > To: (WebCatalog Talk) > Subject: Re: users change an email address > > 2.30 in the afternoon here at the moment .. I think it's 12.30 midday for > Tim .. > >> Hey Alain, I was cleaning up the 2 pages of code to email you, >> but the snippet Tim just came up with to add is starting to work as I want, >> so I'm pursuing that direction for a bit . . . >> >> Thanks to both of you. >> >> (It's nighttime here in Chicago, I assume daytime or near that over where >> you are??) >> >> >> lester >> >> >> >> >> At 12:10 PM 10/2/02, you wrote: >>> 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/ >> >> >> ------------------------------------------------------------- >> 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)
Yes. Beautiful sun, bluest sky you've ever seen..... ;-) -- 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: Alain Russell > Reply-To: (WebCatalog Talk) > Date: Wed, 02 Oct 2002 14:31:53 > To: (WebCatalog Talk) > Subject: Re: users change an email address > > 2.30 in the afternoon here at the moment .. I think it's 12.30 midday for > Tim .. > >> Hey Alain, I was cleaning up the 2 pages of code to email you, >> but the snippet Tim just came up with to add is starting to work as I want, >> so I'm pursuing that direction for a bit . . . >> >> Thanks to both of you. >> >> (It's nighttime here in Chicago, I assume daytime or near that over where >> you are??) >> >> >> lester >> >> >> >> >> At 12:10 PM 10/2/02, you wrote: >>> 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/ >> >> >> ------------------------------------------------------------- >> 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:

What am I missing (1997) [WebDNA] Digest Mode (2008) How to Sort Summ data ? (1997) Flash artist needed (2005) Web Catalog vs. ICAT (1997) Custom WebCat Prefs ... (1997) Is this possible, WebCat2.0 and checkboxes (1997) OT - webserver backups (2003) GoLive CyberStudio 1.0.1 (1997) Running _every_ page through WebCat ? (1997) RE: Adding headers to email (1997) [OT] (waaaay OT) (2004) Search returns all, not 20 (1997) OT: Textarea (2003) TCPconnect and send (2001) Mac: LModelDirector bug fix (1997) [OT] Airport Problem (2003) b12 cannot limit records returned and more. (1997) WCf2 and nested tags (1997) Version 2.0 and 1.6 simultaneous (1997)