numero = 43957
interpreted = N
texte = Well you must have your code in the wrong place in the template. Can you post the source of that page somewhere or email it to me off list - I'll have a look .. Alain> 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:
Well you must have your code in the wrong place in the template. Can you post the source of that page somewhere or email it to me off list - I'll have a look .. Alain> 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/
Alain Russell
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...