Re: users change an email address

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43962
interpreted = N
texte = 9:45 pm here in downtown Chicago>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/ ------------------------------------------------------------- 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)
9:45 pm here in downtown Chicago>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/ ------------------------------------------------------------- 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/ Lester Emo

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:

can WC render sites out? (1997) Math (1997) HELP WITH DATES (1997) Dreamweave MX/WebDNA (2003) Summing a field full of numbers ... (1997) Foreign Chars ( יאצה and so on) (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Sequential Code Logic (2003) Image maps/Webcat (1997) help with autenticate (1998) Quit revisited (1997) PIXO (1997) James Hawker (1998) special commerce fields (1997) Code intermittently reverts to previous state (2000) [taxRate] [TaxTotal] ? (1997) [SearchString] problem with [search] context (1997) 4.01 broken pages using ShowNext (2000) Stop the madness. (1997) Showif Question (2001)