Re: [LookUp]
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23644
interpreted = N
texte = whoops i replied to the wrong one before. i meant to reply to this one.i really should sleep.>>I am doing a simple [lookup], but since [UpAllNight]=T I am making what>>is probably a stupid mistake. Can anyone see it??>>>>[HideIf [action]=Register]>>
>>[/HideIf]>>[ShowIf [action]=Register]>>[!]Checks to make sure both passwords are the same[/!]>>[ShowIf [__Pass]![__PassC]]You have entered 2 different passwords - Try>>again loser[/ShowIf]>>[ShowIf [__Pass]=[__PassC]]>>>>[!]Part of login.tpl[/!]>>[!]This is the line of code giving me probs[/!]>>>>[ShowIf [Lookup>>db=Users.db&Value=[__Name]&LookInField=NAME&ReturnField=NAME&NotFound=T]=T]>>Your OK[/ShowIf]>>>>[/ShowIf]>>[/ShowIf]>>>It doesn't work because of two things:>>1-Lookups are CASE-SENSITIVE but you're not forcing the [__Name] value to >be UPPERCASE in the lookup ... and even if you did, all the [__Name] >values in the db would have to be UPPERCASE to begin with.>>I have found that it's easiest to force the original entry of these values >to be all UPPERCASE characters when appended or replaced in the db, then >in the lookup you can wrap the value in an [uppercase] context to make >webcat give you the results you seek.>>2- The NotFound=T parameter should be NotFound=F to prevent the showif >from executing when the record doesn't exist.>>Sincerely,>Ken Grome>WebDNA Consultant>>>>>--_______________________________________________________________Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 609-273-3721
Associated Messages, from the most recent to the oldest:
whoops i replied to the wrong one before. i meant to reply to this one.i really should sleep.>>I am doing a simple
[lookup], but since [UpAllNight]=T I am making what>>is probably a stupid mistake. Can anyone see it??>>>>[HideIf [action]=Register]>>
>>[/HideIf]>>[ShowIf [action]=Register]>>
[!]Checks to make sure both passwords are the same[/!]>>[ShowIf [__Pass]![__PassC]]You have entered 2 different passwords - Try>>again loser[/ShowIf]>>[ShowIf [__Pass]=[__PassC]]>>>>
[!]Part of login.tpl[/!]>>
[!]This is the line of code giving me probs[/!]>>>>[ShowIf [Lookup>>db=Users.db&Value=[__Name]&LookInField=NAME&ReturnField=NAME&NotFound=T]=T]>>Your OK[/ShowIf]>>>>[/ShowIf]>>[/ShowIf]>>>It doesn't work because of two things:>>1-Lookups are CASE-SENSITIVE but you're not forcing the [__Name] value to >be UPPERCASE in the lookup ... and even if you did, all the [__Name] >values in the db would have to be UPPERCASE to begin with.>>I have found that it's easiest to force the original entry of these values >to be all UPPERCASE characters when appended or replaced in the db, then >in the lookup you can wrap the value in an
[uppercase] context to make >webcat give you the results you seek.>>2- The NotFound=T parameter should be NotFound=F to prevent the showif >from executing when the record doesn't exist.>>Sincerely,>Ken Grome>WebDNA Consultant>>>>>--_______________________________________________________________Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 609-273-3255Fax# 609-273-3721
charles kline
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:
Writing [raw] to a file (2000)
[WebDNA] comma bug (2015)
quit command on NT (1997)
Press Release hit the NewsWire!!! (1997)
WebCat2b15MacPlugin - showing [math] (1997)
A sendmail warning (2005)
Multiple Users.db Possible? (1997)
View a Order file (1999)
politeness (was searches with dash...) Please Read (2000)
ODBC / Paradox help needed (2005)
Bug or syntax error on my part? (1997)
Sendmail & Time Issue (2001)
Math inside [showif] (1998)
service stop and restart (1997)
Problems getting parameters passed into email. (1997)
Spiders (1998)
gateway application timeouts (1998)
CSS problem (2000)
Execute Applescript (1997)
webcat sendmail error - unix sendmail failed to deliver this email (2000)