numero = 43960
interpreted = N
texte = 2.30 in the afternoon here at the moment .. I think it's 12.30 midday forTim .. > 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/
Associated Messages, from the most recent to the oldest:
2.30 in the afternoon here at the moment .. I think it's 12.30 midday forTim .. > 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/
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...