Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67877
interpreted = N
texte = Can't get my brain around this one. Our orders are written to 2 databases, orders.db and lineitems.db. I want to display a summary listing of the quantities of the skus for all of the orders that haven't been filled so we can pick them from the warehouse. So, if I had several orders like this: Order 1: sku qty ----------------- 001 5 003 1 Order 2: sku qty ----------------- 001 1 004 12 006 5 My results would look like: sku qty ------------------ 001 6 003 1 004 12 006 5 But how? I can get a non summated listing by doing: [search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [sku] [quantity] [/founditems] [/search] [/founditems] [/search] But how do I get a summated listing? It seems [table] should do what I want, but I'm not certain how to code this inside a nested search. Any ideas? -- Will Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-892-4149 ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Can't get my brain around this one. Our orders are written to 2 databases, orders.db and lineitems.db. I want to display a summary listing of the quantities of the skus for all of the orders that haven't been filled so we can pick them from the warehouse. So, if I had several orders like this: Order 1: sku qty ----------------- 001 5 003 1 Order 2: sku qty ----------------- 001 1 004 12 006 5 My results would look like: sku qty ------------------ 001 6 003 1 004 12 006 5 But how? I can get a non summated listing by doing: [search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [sku] [quantity] [/founditems] [/search] [/founditems] [/search] But how do I get a summated listing? It seems [table] should do what I want, but I'm not certain how to code this inside a nested search. Any ideas? -- Will Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-892-4149 ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
WJ Starck
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:
Interfacing WebMerchant to www.fedex.com (1997)
Date and Time Analyzer (2000)
[OT] Ave. Hits Per Day (2006)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
REPOST: WebCat & WebSTAR V (2002)
Using Plug-In while running 1.6.1 (1997)
automating txt downloads for conversion to webcat db (2006)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
[dos] command (1997)
Help! (1996)
How many lookups does it take ... (2003)
Replacing a Word (1999)
cookies and [returnraw] (1997)
Associative lookup style? + bit more (1997)
Need relative path explanation (1997)
[include ...] behavior (1997)
Goodbyes (2007)
1st Comparison inside [fileinfo] broken. = bug? (2004)
Wait, I forgot something! (was authenticating a seconduser, the sequel) (1997)
Search 1 Field Twice? (2004)