Re: users change an email address

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 43959
interpreted = N
texte = 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??)lesterAt 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/ Associated Messages, from the most recent to the oldest:

Re: users change an email address (Lester Emo 2002) Re: users change an email address (Tim Robinson 2002) Re: users change an email address (Alain Russell 2002) Re: users change an email address (Lester Emo 2002) Re: users change an email address (Tim Robinson 2002) Re: users change an email address (Alain Russell 2002) Re: users change an email address (Lester Emo 2002) Re: users change an email address (Alain Russell 2002) users change an email address (Lester Emo 2002)

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??)lesterAt 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/ 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:

taxrate - off by 1 cent (1997) Setting up WebCatalog with Retail Pro data (1996) Limiting user access to .tmpl files (1997) WCS Newbie question (1997) [WebDNA] grep again (2010) Include a big block of text (1997) WebCatalog can't find database (1997) Timer Values on [redirect] (1998) Error:Too many nested [xxx] contexts (1997) searchable list archive (1997) Striping Characters (1998) Pithy questions on webcommerce & siteedit (1997) More DateMath problems (1997) ConvertChars (1998) auto enter dates (1998) Possible Bug in 2.0b15.acgi (1997) Re[2]: Re[2]: OT: Amazon Patents (2000) default error on NT? (1997) Sort Order on a page search (1997) format_to_days on NT (1997)