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:
writefile and deletefile (1998)
WebCatalog2 Feature Feedback (1996)
OT: WebDNA and LINUX (2004)
PSC recommends what date format yr 2000??? (1997)
Open Market's Transact & Macintosh (1998)
WebCat2 Append problem (B14Macacgi) (1997)
Shopping cart problem (2003)
if else problem (2003)
New NT beta available (1997)
emailer (1997)
WebCatalog and Webstar 3.02 (1998)
OK, here goes... (1997)
RE: what characters are replaced for tab and CR? (1998)
Am I going senile? (Price recalc based on quantity) (1997)
PCS Frames (1997)
Use of Back and Reload Buttons on ShoppingCart page? (1997)
Country & Ship-to address & other fields ? (1997)
More on the email templates (1997)
[url] issue (2000)
Swear words (2002)