Re: lookups

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28273
interpreted = N
texte = on 2/29/2000 1:44 PM, Eric palhof at eric@pcproduction.com wrote:> 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 > 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]Mike ------------------------------------------------------------- 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)
on 2/29/2000 1:44 PM, Eric palhof at eric@pcproduction.com wrote:> 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 > 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]Mike ------------------------------------------------------------- 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 Mike Davis

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:

[WebDNA] a major shift in strategy? (2008) acgi to plugin migration problems (2000) Emailer 1.01 bombs (1997) WebCat2.0 [format thousands .0f] no go (1997) Problem (1997) emailer (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) PCS Frames (1997) Shopping carts and reloading pages (1997) Small problem (2001) Upgrading old WebCat Database Files (1997) Test (2003) WC Database Format (1997) can WC render sites out? (1997) multiple search commands (1997) How To question on setting up downloads (1997) CommitDatabase vs. CloseDatabase (2001) F2 to F3 rocky transition (1997) Emailer (1997) No luck with taxes (1997)