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:

    
  1. Re: [WebDNA] max number of searches and lookups on a page (Kenneth Grome 2016)
  2. Re: [WebDNA] max number of searches and lookups on a page ("Matthew A Perosi, Psi Prime" 2016)
  3. Re: [WebDNA] max number of searches and lookups on a page (Richard Kwasniewski 2016)
  4. Re: [WebDNA] max number of searches and lookups on a page (Kenneth Grome 2016)
  5. [WebDNA] max number of searches and lookups on a page (Richard Kwasniewski 2016)
  6. Re: US Postal Service and United Parcel Service XML Lookups ( Velma Kahn 2003)
  7. Re: US Postal Service and United Parcel Service XML Lookups ( Donovan 2003)
  8. US Postal Service and United Parcel Service XML Lookups ( Velma Kahn 2003)
  9. Re: XML - USPS Lookups - UPS Lookups ( Donovan 2003)
  10. Re: XML - USPS Lookups - UPS Lookups ( Velma Kahn 2003)
  11. Re: XML - USPS Lookups - UPS Lookups ( Clint Davis 2003)
  12. Re: Fwd: XML - USPS Lookups - UPS Lookups ( "Larry Goodhew" 2003)
  13. Re: XML - USPS Lookups - UPS Lookups ( Scott Anderson 2003)
  14. Fwd: XML - USPS Lookups - UPS Lookups ( Velma Kahn 2003)
  15. XML - USPS Lookups - UPS Lookups ( Velma Kahn 2003)
  16. Re: How many lookups does it take ... ( "WebDna @" 2003)
  17. Re: How many lookups does it take ... ( Tim Robinson 2003)
  18. Re: How many lookups does it take ... ( "WebDna @" 2003)
  19. Re: How many lookups does it take ... ( "WebDna @" 2003)
  20. Re: How many lookups does it take ... ( Glenn Busbin 2003)
  21. Re: How many lookups does it take ... ( Bob Minor 2003)
  22. Re: How many lookups does it take ... ( Brian Fries 2003)
  23. Re: How many lookups does it take ... ( "WebDna @" 2003)
  24. How many lookups does it take ... ( "WebDna @" 2003)
  25. Re: Lookups (jpeacock@univpress.com 2000)
  26. Re: Lookups (Paul Fowler 2000)
  27. Re: Lookups (Kenneth Grome 2000)
  28. Lookups (Paul Fowler 2000)
  29. Re: lookups (Eric palhof 2000)
  30. Re: lookups (Kenneth Grome 2000)
  31. Re: lookups (Eric Ridgley 2000)
  32. Re: lookups (Mike Davis 2000)
  33. Re: lookups (Howard Wolosky 2000)
  34. Re: lookups (Mike Davis 2000)
  35. lookups (Eric palhof 2000)
  36. Re: Zip Code Lookups (Jesse Williams Proudman 1999)
  37. Zip Code Lookups (John Winningham 1999)
  38. UPS/FEDEX/OTHER Ship lookups available?? (Scott Szretter 1998)
  39. Re: Nested Lookups (Kenneth Grome 1998)
  40. Re: Nested Lookups (Bob Minor 1998)
  41. Nested Lookups (Puchalski, Steve 1998)
  42. Re: lookups or math? (Kenneth Grome 1998)
  43. Re: lookups or math? (Grant Hulbert 1998)
  44. lookups or math? (Kenneth Grome 1998)
  45. Re: case sensitivity in lookups (Grant Hulbert 1997)
  46. Re: case sensitivity in lookups (John Hill 1997)
  47. case sensitivity in lookups (Jim Turney 1997)
  48. Re: case sensitivity in lookups (Kenneth Grome 1997)
  49. Re: & in Lookups (Michael Winston 1997)
  50. Re: & in Lookups (Grant Hulbert 1997)
  51. Re: & in Lookups (John Hill 1997)
  52. Re: & in Lookups (Michael Winston 1997)
  53. Re: & in Lookups (John Hill 1997)
  54. Re: & in Lookups (Kenneth Grome 1997)
  55. Re: & in Lookups (Michael Winston 1997)
  56. Re: & in Lookups (Michael Winston 1997)
  57. Re: & in Lookups (Trevor Crist 1997)
  58. & in Lookups (Michael Winston 1997)
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:

FW: Shipping calculations (1997) Problems with [Applescript] (1997) Help name our technology! (1997) WebCat2 beta FTP site (1997) Emailer tracking (1997) PageMaker/Quark to db (1999) argh must send var to iframe to load webDNA search (2003) Funny Submissions From a Form Page (1999) The beginning (1997) price totals (2003) CA sales tax (1998) webcat2b12 CGI -- Date comparisons (1997) date to days? (2005) WebCat2b12--[searchstring] bug (1997) Pull down menu for categories (2000) Help! WebCat2 bug (1997) OK, here goes... (1997) Signal Raised error (1997) FW: Shipping calculations (1997) Field Totals (2004)