Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67890
interpreted = N
texte = I do something similar on one of my sites. I use a math variable to add 'em up as I go.Initialize pick[sku] with 0 if it is raw, or initialize the whole db of skus first off if not too unwieldy. Then put [math show=f]pick[sku]=pick[sku]+[qty][/math] with the line item as shown for sku 001 in your sample below.This is off the top of my head typed quickly, so beware of typos and such.Terry>From: WJ Starck
>Subject: Summing results of a nested search>Date: Mon, 7 Aug 2006 11:29:01 -0500>>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:>>skuqty>----------------->0015 [math show=f]pick[sku]=pick[sku]+[qty][/math]>0031>>Order 2:>skuqty>----------------->0011 [math show=f]pick[sku]=pick[sku]+[qty][/math]>00412>0065>>My results would look like:>>skuqty>------------------>001[interpret][pick[sku]][/interpret]>0031>00412>0065>>But how?-- Terry Wilson | terry@terryfic.com | http://terryfic.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightPods.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.-------------------------------------------------------------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:
I do something similar on one of my sites. I use a math variable to add 'em up as I go.Initialize pick[sku] with 0 if it is raw, or initialize the whole db of skus first off if not too unwieldy. Then put [math show=f]pick[sku]=pick[sku]+[qty][/math] with the line item as shown for sku 001 in your sample below.This is off the top of my head typed quickly, so beware of typos and such.Terry>From: WJ Starck >Subject: Summing results of a nested search>Date: Mon, 7 Aug 2006 11:29:01 -0500>>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:>>skuqty>----------------->0015 [math show=f]pick[sku]=pick[sku]+[qty][/math]>0031>>Order 2:>skuqty>----------------->0011 [math show=f]pick[sku]=pick[sku]+[qty][/math]>00412>0065>>My results would look like:>>skuqty>------------------>001[interpret][pick[sku]][/interpret]>0031>00412>0065>>But how?-- Terry Wilson | terry@terryfic.com | http://terryfic.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://TightPods.com -- stylish protection for your laptop--------------------------------------------------------------------------Attitude is the only difference between ordeal and adventure.-------------------------------------------------------------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/
Terry Wilson
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:
how to put/keep product customization info in basket? (1998)
Multiple serial numbers (1997)
WebMerch/Emailer Error (1998)
More Applescript (1997)
update on include (1997)
Email Obfuscation Function (2008)
WebCat2 - Getting to the browser's username/password data (1997)
how realize an advertiser ? (2005)
[format 40s]text[/format] doesn't work (1997)
Error reading data -1 (1997)
OT: Webinars and remote desktop control (2003)
can you use [middle] in a search? (2001)
using webdna to determine pixel parameters (2000)
Re:Webmessage Hyperboard (1998)
Wireless WebDNA available today! (2000)
Code for Accessing E-mail Accounts (2005)
FAX orders (1996)
Admin Edit prob. (1997)
html vs csi (Was: OT: 800x600) (2003)
Caching [include] files ... (1997)