Re: Summing results of a nested search

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67880
interpreted = N
texte = Perhaps this (untested): [search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [search db=lineitems.db&eqskudatarq=[sku]] [founditems] [sku] [sum field=quantity] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] Gary At 11:29 AM 8/7/2006, you wrote: >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? ------------------------------------------------------------- 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)
Perhaps this (untested): [search db=orders.db&nefilledata=T] [founditems] [search db=lineitems.db&neskudata=[blank]] [founditems] [search db=lineitems.db&eqskudatarq=[sku]] [founditems] [sku] [sum field=quantity] [/founditems] [/search] [/founditems] [/search] [/founditems] [/search] Gary At 11:29 AM 8/7/2006, you wrote: >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? ------------------------------------------------------------- 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/ Gary Krockover

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:

Duplicate Carts (2000) Calendar sample (1998) can WC render sites out? (1997) RE: WebCatalog2 for NT Beta Request (1997) Upgrading old WebCat Database Files (1997) Security Question (1997) Error:Too many nested [xxx] contexts (1997) WebCat2b15MacPlugin - [protect] (1997) Non-technical messages ... (1997) Opening 'order file'. (1999) Server Freeze (1998) Error Log.db --however (1997) Mac 2.1b4 unknown error: BadSuffix (1997) Cookies and webcat (1997) Fun with Dates - finally resolved but.... (1997) PCS Frames (1997) starting news site + small store (2000) [OT] HTML Table Cell Problem (2003) Cookies not setting on IE (2002) [WebDNA] CSS Advice (2008)