Nested Lookups

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20842
interpreted = N
texte = This may be a dumb question, but is it possible to nest lookups within a formula. What I am trying to do is to use a customer's account number to determine their pricing code, then perform another lookup in a separate database based on the result. The code I tried is: Price[lookup db=cusmas.db&lookinfield=SKU&value=[Account]&returnfield=Price Code][lookup db=price[Price Code].txt&lookinfield=SKU&returnfield=Price][/lookup][/lookup]All this does is return the Price Code from the first lookup. I have databases called Price1.txt, Price2.txt etc. that I am trying to access to ultimately deliver the correct pricing for the customer. Any and all ideas will be greatly appreciated.Steve Puchalski Spuchalski@alltechemail.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Nested Lookups (Kenneth Grome 1998)
  2. Re: Nested Lookups (Bob Minor 1998)
  3. Nested Lookups (Puchalski, Steve 1998)
This may be a dumb question, but is it possible to nest lookups within a formula. What I am trying to do is to use a customer's account number to determine their pricing code, then perform another lookup in a separate database based on the result. The code I tried is: Price[lookup db=cusmas.db&lookinfield=SKU&value=[Account]&returnfield=Price Code][lookup db=price[Price Code].txt&lookinfield=SKU&returnfield=Price][/lookup][/lookup]All this does is return the Price Code from the first lookup. I have databases called Price1.txt, Price2.txt etc. that I am trying to access to ultimately deliver the correct pricing for the customer. Any and all ideas will be greatly appreciated.Steve Puchalski Spuchalski@alltechemail.com Puchalski, Steve

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:

Searching a database... (2003) ConvertChars request (1999) America Online Issues (1998) [shownext] and descending order (1997) How to verify email address (1997) Unformatted Messages (1998) Fun with Dates - finally resolved but.... (1997) Next (1997) unable to launch acgi in WebCat (1997) help testing quicktime delivery (1997) [WebDNA] Escaping content for JSON (2013) [WebDNA] EMailFolder/ (2016) Questions To Answer (1997) WebDNA Solutions ... sorry! (1997) Removing items from a cart is wonky... (1998) Problems searching from a FORM (1997) [isfolder] and [filename] (1997) WebCat2 beta 11 - new prefs ... (1997) Robots fill event log (1997) Problems getting parameters passed into email. (1997)