Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67887
interpreted = N
texte = I couldn't get that to work. Is that 6.x syntax (I'm running 5.1)?Also, while we're at it, this search [search db=../orders.db&neshippeddatarq=T&eqapproveddatarq=T]seems to ignore the [approved] field, i.e., it shows all records that have not been shipped regardless of whether they have been approved or not.I want all records that have been approved *and* have not shipped.Is there something missing from my syntax?Thanks,WillOn Aug 7, 2006, at 4:20 PMCDT, Gary Krockover wrote:> I thought that's what [sum field=] was for?>> GJK>> At 03:20 PM 8/7/2006, you wrote:>> [math show=f]quantity[sku]=([interpret][quantity[sku]] [/interpret] >> +[quantity])[/math]>>> -------------------------------------------------------------> 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/--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comhelpdesk@novaderm.com866-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:
I couldn't get that to work. Is that 6.x syntax (I'm running 5.1)?Also, while we're at it, this search [search db=../orders.db&neshippeddatarq=T&eqapproveddatarq=T]seems to ignore the [approved] field, i.e., it shows all records that have not been shipped regardless of whether they have been approved or not.I want all records that have been approved *and* have not shipped.Is there something missing from my syntax?Thanks,WillOn Aug 7, 2006, at 4:20 PMCDT, Gary Krockover wrote:> I thought that's what [sum field=] was for?>> GJK>> At 03:20 PM 8/7/2006, you wrote:>> [math show=f]quantity[sku]=([interpret][quantity[sku]] [/interpret] >> +[quantity])[/math]>>> -------------------------------------------------------------> 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/--Will StarckNovaDerm Skincare Sciencehttp://www.novaderm.comhelpdesk@novaderm.com866-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:
Dumb Question about Docs (1997)
BBEdit and WebCatalog 2.0? (1997)
[OT] Airport Problem (2003)
[format xs] freeze (1997)
Authenticate (1997)
LIstFiles - filnames are cart numbers. (2000)
protect tag on NT IIS (1997)
Purchased cart being overwritten - still !?? (1997)
Adding multiple items to Cart at one time, & append context problem (1998)
Comments in db? (1997)
Welcome Back (was) Newbie Question (1999)
Replace context problem ... (1997)
date (1998)
Digest for 4/18/97 (1997)
Safari cookies (2006)
What am I missing (1997)
Help w/ Duplicating The General Store 5 times. (1997)
Needed, Freelance Web Developer (2007)
WebCat ignoring Shopping Cart Folder (2001)
WebCat2b13MacPlugIn - More limits on [include] (1997)