Re: lookups
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28277
interpreted = N
texte = Your Code:[lookup db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]I think this is Correct:[lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity¬found=NA]Because the value=[sku] means you are searching on the sku right?If so, the LookInField should be the sku field. The name/value pair for thevalue attribute just indicates what sku number you are looking up, you thenhave to tell WebCat what field to look in with the LookInField name/valuepair attribute. The return field is the information it returns. Also youforgot the 'notfound=' in front of your NA plus you do not need the quotemarks.Here is the code from the online Command Reference:[LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField=fieldName¬Found=TextIfNotFound]> From: Eric palhof
> Reply-To: (WebCatalog Talk)> Date: Tue, 29 Feb 2000 16:44:55> To: (WebCatalog Talk)> Subject: lookups> > I am trying to write a lookup and nothing works.> > ....TD>[lookup > db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]> > > I want to lookup the values in the Quantity field of the DB. These values> are different than Quantity in a WebCatalog tag. They are actually Quantity> On Hand and I want the viewer to see their exisitng inventory to decide how> much they can order. I then want to substract the ordered amount from the> existing total. Can anyone help?> > -------------------------------------------------------------> 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> -------------------------------------------------------------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:
Your Code:[lookup db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]I think this is Correct:[lookup db=Briggs.db&value=[sku]&lookInfield=sku&returnfield=Quantity¬found=NA]Because the value=[sku] means you are searching on the sku right?If so, the LookInField should be the sku field. The name/value pair for thevalue attribute just indicates what sku number you are looking up, you thenhave to tell WebCat what field to look in with the LookInField name/valuepair attribute. The return field is the information it returns. Also youforgot the 'notfound=' in front of your NA plus you do not need the quotemarks.Here is the code from the online Command Reference:[LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField=fieldName¬Found=TextIfNotFound]> From: Eric palhof > Reply-To: (WebCatalog Talk)> Date: Tue, 29 Feb 2000 16:44:55> To: (WebCatalog Talk)> Subject: lookups> > I am trying to write a lookup and nothing works.> > ....TD>[lookup > db=Briggs.db&value=[sku]&lookInfield=[Quantity]&returnfield=[Quantity]&NA]> > > I want to lookup the values in the Quantity field of the DB. These values> are different than Quantity in a WebCatalog tag. They are actually Quantity> On Hand and I want the viewer to see their exisitng inventory to decide how> much they can order. I then want to substract the ordered amount from the> existing total. Can anyone help?> > -------------------------------------------------------------> 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> -------------------------------------------------------------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
Eric Ridgley
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:
extending webcatalog (1997)
WebCatalog and directory indexing (1998)
Reversed words (1997)
Max Record length restated as maybe bug (1997)
Creating a folder with WebCat? (2000)
Newbie Help Needed (1998)
No shipping systems available? (1998)
[WebDNA] CICADA (2009)
UPS (2003)
Unexpected error (1997)
Robert Minor duplicate mail (1997)
Kill the webcat process (2000)
Cache Access Error (2000)
problems with 2 tags (1997)
GuestBook example (1997)
Thanks and Big News!!! (1997)
searching by date (1998)
View order not right (1997)
Location of Browser Info.txt file (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)