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 RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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][/ur>> 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:
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 RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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][/ur>> 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
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...