Re: [LookUp]
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23645
interpreted = N
texte = Hey wait. I figured it out. It was not a problem with my template (at least the way I was testing it) the problem was that i did not have the entry in the .db correctly...ooops.>>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:
Hey wait. I figured it out. It was not a problem with my template (at least the way I was testing it) the problem was that i did not have the entry in the .db correctly...ooops.>>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:
Sherlock and WebCat (1998)
[shownext max=?] armed (1997)
ampersand (1998)
Batch upload (2005)
Hard Questions ? (1997)
credit card (1997)
Missing from Docs [folderName] (1997)
PCS Frames (1997)
FORMS: Returning a specific page (1997)
I have observed and I am gone. (1998)
[LOOKUP] (1997)
RAM variables (1997)
Re:Item options w/ price adjustment (1997)
ThreadMem ignored? (1998)
[ShowIf] and empty fields (1997)
Been meaning to ask... (1997)
Attention SM: Trigger Bug? (2000)
Re:I want my files to have an asp file extension (1999)
Here we go again... (2006)
different show next (1997)