numero = 43961
interpreted = N
texte = Yes. Beautiful sun, bluest sky you've ever seen..... ;-)-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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:
Yes. Beautiful sun, bluest sky you've ever seen..... ;-)-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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
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...