Re: [LOOKUP]
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11771
interpreted = N
texte = >>I can't get the [LOOKUP] tag to return anything other than NotFound text>>string. I'm referencing a database that has 2 fields (sku and description).>>>>I've spelled the field names correctly. I have the comment>>in the page.>>>>What's wrong?!>>>>[LOOKUP>>db=../DB/description.db&value=94215&lookInField=[sku]&returnField=[descript>>ion]&>>notFound=Sorry, there is no profile available for this item.]>>>>I'm using the WC plugin (f3).John's right, in most cases you don't want touse brackets around the fieldnames in the lookup database ...... also, don't forget that lookup requires an exact - CASE SENSITIVE -match of the 'value' parameter. It's really FAST, but it's not as flexibleas [search] because it requires an exact match ...Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html
Associated Messages, from the most recent to the oldest:
>>I can't get the
[lookup] tag to return anything other than NotFound text>>string. I'm referencing a database that has 2 fields (sku and description).>>>>I've spelled the field names correctly. I have the comment>>in the page.>>>>What's wrong?!>>>>[LOOKUP>>db=../DB/description.db&value=94215&lookInField=[sku]&returnField=[descript>>ion]&>>notFound=Sorry, there is no profile available for this item.]>>>>I'm using the WC plugin (f3).John's right, in most cases you don't want touse brackets around the fieldnames in the lookup database ...... also, don't forget that lookup requires an exact - CASE SENSITIVE -match of the 'value' parameter. It's really FAST, but it's not as flexibleas
[search] because it requires an exact match ...Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html
Kenneth Grome
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:
Quick Question (1997)
New Guestbook Source (1997)
Date search - yes or no (1997)
WebCat2b13MacPlugIn - [include] (1997)
WARNING: MacOS The installer is broken... (2000)
Comments in db? (1997)
WebMerchant and PCAuthorize (1998)
add to cart within a page? (1997)
webcatalog [date] bug...not (1999)
RE: [WebDNA] Friday's.. WIP thread (2009)
WCS Newbie question (1997)
Formating Tables w/[founditems] (1998)
Data Problem (2004)
Best Place for AuthorizeNet Call (2003)
2.0Beta Command Ref (can't find this instruction) (1997)
Expiration of Carts (1997)
math on date? (1997)
RE: Web*SSL and WebCatalog (1997)
OT:looking for developers with solutions (2000)
Reminder for beta testers (2000)