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.com http://WhosComing.com - a simplified, affordable online reservation system http://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:

    
  1. Re: Summing results of a nested search ( Terry Wilson 2006)
  2. Re: Summing results of a nested search ( WJ Starck 2006)
  3. Re: Summing results of a nested search ( Stuart Tremain 2006)
  4. Re: Summing results of a nested search ( WJ Starck 2006)
  5. Re: Summing results of a nested search ( Gary Krockover 2006)
  6. Re: Summing results of a nested search ( WJ Starck 2006)
  7. Re: Summing results of a nested search ( WJ Starck 2006)
  8. Re: Summing results of a nested search ( WJ Starck 2006)
  9. Re: Summing results of a nested search ( Gary Krockover 2006)
  10. Re: Summing results of a nested search ( Clint Davis 2006)
  11. Summing results of a nested search ( WJ Starck 2006)
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.com http://WhosComing.com - a simplified, affordable online reservation system http://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)