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:
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
Multiple Merchant Accounts? (1997)
[OT] "Hacker Safe" (2007)
WebCat2 - many [carts] on one template page? (1997)
WebCat2 - storing unformatted date data? (1997)
Erotic Sites (1997)
shipcost (1997)
WebCatalog/WebMerchant Manuals Available (1998)
Missing from Docs [folderName] (1997)
CyberCash not responding (2003)
math a various prices (1997)
checkbox results written to a database (1999)
Associative lookup style? + bit more (1997)
NT or Mac (1997)
Convertchars Problem (2004)
[Price] (1997)
Simple way to create unique SKU (1997)
Candle Light Vigil (2001)
Searching Multiple DBs (1997)
PCS Frames-Default page is solution! (1997)