Re: lookups
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28279
interpreted = N
texte = >on 2/29/2000 1:48 PM, Mike Davis at admin@network13.net wrote:>>> Remove the brackets, unless your field is named [Quantity] literally.>> Should read:>> [lookup>> db=Briggs.db&value=[sku]&lookInfield=Quantity&returnfield=Quantity&NA]>> but I doubt you are going to find the SKU value in your Quantity field. You>> probably want to do this:>> [lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity&NA]>And just noticed the &NA, which is not proper syntax either.>Try>¬found=out of stock>or something to that effect.>Don't use quotes.And don't forget that lookups are case sensitive, so abc123 does NOT match ABC123 in a lookup ...================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
>on 2/29/2000 1:48 PM, Mike Davis at admin@network13.net wrote:>>> Remove the brackets, unless your field is named [Quantity] literally.>> Should read:>> [lookup>> db=Briggs.db&value=[sku]&lookInfield=Quantity&returnfield=Quantity&NA]>> but I doubt you are going to find the SKU value in your Quantity field. You>> probably want to do this:>> [lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity&NA]>And just noticed the &NA, which is not proper syntax either.>Try>¬found=out of stock>or something to that effect.>Don't use quotes.And don't forget that lookups are case sensitive, so abc123 does NOT match ABC123 in a lookup ...================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
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:
Some ThankYou page problems (1997)
Searching multiple Databases (1997)
Shopping Cart variation... (1997)
WebCat2 - [format thousands] (1997)
Bulk Linebreak Changes (2002)
Week # problem (1998)
WEBCAT with SQL backend. Help please! (2000)
no template caching (1997)
Re:no [search] with NT (1997)
HTML Editors (1997)
[WebDNA] max in a search (2009)
Ship Cost Not working (2000)
Need formum software... (2003)
[searchString] (1997)
Errata: WCS Newbie question (1997)
this works sometimes and sometimes not (1997)
[WebDNA] Needing a new host.... (2013)
Separate SSL Server (1997)
Not carrying Zero (2000)
[OT] Mom's gift (2006)