Re: Summing results of a nested search

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67883
interpreted = N
texte = Thanks. I don't think it's possible to do what I want because it appears to be a database design issue. So, instead, I add a field [filled] to the lineitems database, which gets toggled to "T" when an order is filled. Then, in my template: [!]###--------Initialize variable quantity[sku]-------###[/!] [search db=../catalog.db&eqinstockdatarq=T]  [founditems]  [math show=f]quantity[sku]=0[/math]  [/founditems]  [/search]  [!]###-------do the math-------###[/!]  [search db=../lineitems.db&nefilleddatarq=T]   [founditems] [math show=f]quantity[sku]=([interpret][quantity[sku]][/ interpret]+[quantity])[/math]  [/founditems] [/search]  [!]###-------Display results-------###[/!] [search db=../lineitems.db&nefilleddatarq=T&skusumm=T]   [founditems] [sku] [title] [interpret][quantity[sku]][/interpret]  [/founditems] [/search] That did the trick. Thanks all.... -- Will Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-892-4149 On Aug 7, 2006, at 11:43 AMCDT, Gary Krockover wrote: > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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)
Thanks. I don't think it's possible to do what I want because it appears to be a database design issue. So, instead, I add a field [filled] to the lineitems database, which gets toggled to "T" when an order is filled. Then, in my template: [!]###--------Initialize variable quantity[sku]-------###[/!] [search db=../catalog.db&eqinstockdatarq=T]  [founditems]  [math show=f]quantity[sku]=0[/math]  [/founditems]  [/search]  [!]###-------do the math-------###[/!]  [search db=../lineitems.db&nefilleddatarq=T]   [founditems] [math show=f]quantity[sku]=([interpret][quantity[sku]][/ interpret]+[quantity])[/math]  [/founditems] [/search]  [!]###-------Display results-------###[/!] [search db=../lineitems.db&nefilleddatarq=T&skusumm=T]   [founditems] [sku] [title] [interpret][quantity[sku]][/interpret]  [/founditems] [/search] That did the trick. Thanks all.... -- Will Starck NovaDerm Skincare Science http://www.novaderm.com helpdesk@novaderm.com 866-892-4149 On Aug 7, 2006, at 11:43 AMCDT, Gary Krockover wrote: > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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:

WebCat2: Found Items syntax, etc. (1997) Using Plug-In while running 1.6.1 (1997) CloseDatabase (1997) WC --> printer (1998) OT: Let's see your workspace... (2005) Setting up shop (1997) disappearing SKU (etc.) fields (1998) Robert Minor duplicate mail (1997) Running _every_ page through WebCat-error.html (1997) New syntax feedback for 4.0 (2000) Problems getting parameters passed into email. (1997) Adding new customer numbers sequentially (1997) Some ThankYou page problems (1997) color and size options (1997) GuestBook example (1997) Almost a there but..bye bye NetCloak (1997) expire headers in mac305b11 (1999) Browser security type (2000) Fwd: Emailer Error code 530? SMITHMICRO (2002) Timeout question .. (2003)