numero = 43956
interpreted = N
texte = Nope. Didn't work . . .even tried it with eqEMAILdatarqI had tried a similar search earlier as wellIn my scenario:A user has an email like emo@emo.comA 2nd user logs in, and can change his email to be emo@emo.comNot 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][/url> > ]&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/
Associated Messages, from the most recent to the oldest:
Nope. Didn't work . . .even tried it with eqEMAILdatarqI had tried a similar search earlier as wellIn my scenario:A user has an email like emo@emo.comA 2nd user logs in, and can change his email to be emo@emo.comNot 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][/url> > ]&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/
Lester Emo
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...