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:
re: How can I record purchases to a database? (1998)
default error on NT? (1997)
A quickie question (1997)
Simple way to create unique SKU (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
creating a ShipCosts database (1997)
Access Denied! But why? (1997)
[WebDNA] How to build a Ubuntu 18.04 server on DigitalOcean (2019)
Duplicate Carts (2000)
[shipTotal] or [shippingTotal] ??? (1998)
Is Typhoon 4 or Typhoon Pro a product? (2000)
Bug or syntax error on my part? (1997)
_ in front of field name (1998)
checkout.tpl (1999)
[urgent] Phone number at SM (2006)
FEW QUESTIONS (1997)
[append] vs. [appendfile] delta + question? (1997)
RE: problems with dos and tracert + webDNA (1998)
Testing (2003)