Re: lookups

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28276
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.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: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.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:

# fields limited? (1997) Apple event reply error (-1) (1997) Email (2000) RE: Fishing: anyone on this group willing to do support? (1998) shipcost (1997) Emailer setup (1997) Bug in 4.5 - Needs to be fixed ASAP. (2002) Users.db [encrypt seed=????] (1998) RE: Going to anchors within a template page (1997) RE: [WebDNA] Cannot get WebDNA and MySQL working. (2015) WebDNA on OS X Tiger (2006) Cumulative Shipping charge calculations - your help please. (1997) WebCat2: multiple currency support (1997) setitems, one more thing (1997) whole word matching (2004) You are not allowed to change the price (2003) Nested tags count question (1997) Poll Please (2002) Cookie problems using Mozilla and Camino browsers (2004) [BULK] [WebDNA] [BULK] 7.x and 6.x on same server (2012)