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 the value attribute just indicates what sku number you are looking up, you then have to tell WebCat what field to look in with the LookInField name/value pair attribute. The return field is the information it returns. Also you forgot the 'notfound=' in front of your NA plus you do not need the quote marks.Here is the code from the online Command Reference: [LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField=fieldN ame¬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 the value attribute just indicates what sku number you are looking up, you then have to tell WebCat what field to look in with the LookInField name/value pair attribute. The return field is the information it returns. Also you forgot the 'notfound=' in front of your NA plus you do not need the quote marks.Here is the code from the online Command Reference: [LOOKUP db=databasePath&value=searchValue&lookInField=searchField&returnField=fieldN ame¬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:
shipcost (1997)
Web Catalog vs. ICAT (1997)
Help with sorting search results sorting (1998)
Has anyone accessed an LDAP server via Typhoon Pro? (2000)
Emailer (1997)
Calculating multiple shipping... (1997)
[Announce]: Web server security and password protection (1997)
newcart (1997)
Logging purchases (1997)
purchase.log file (1997)
Great product and great job ! (1997)
Webstar 1.3.1 PPC (1997)
Nested tags count question (1997)
Problem with version 4 browsers (1998)
hideif glitch (2003)
Configuring E-mail (1997)
Document Contains no data, or showcart error. (1997)
remotely add + sign (1997)
Images (2000)
WebCatalog-NT?'s (1996)