Re: Summing results of a nested search
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67888
interpreted = N
texte = Flushed db, typoThey are usually the culpritsStuart Tremainidfk web developments, sydney, australiaOn 08 Aug 2006, at 8:00 AM, WJ Starck wrote:> 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,>> Will>>> On 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 Starck> NovaDerm Skincare Science> http://www.novaderm.com> helpdesk@novaderm.com> 866-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 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:
Flushed db, typoThey are usually the culpritsStuart Tremainidfk web developments, sydney, australiaOn 08 Aug 2006, at 8:00 AM, WJ Starck wrote:> 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,>> Will>>> On 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 Starck> NovaDerm Skincare Science> http://www.novaderm.com> helpdesk@novaderm.com> 866-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 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/
Stuart Tremain
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:
Feature requests (1998)
Authenticating users without dialog box (1997)
using webcat with web* & web*SSL (1998)
problems with 2 tags shakur (1997)
Multiple fields on 1 input (1997)
Further tests with the infamous shipCost (1997)
emailer stuck (1997)
Separate SSL Server (1997)
SSL and reg web* (1997)
ichat (2003)
Newbie Tax Question (1997)
creator code (1997)
Show new (2003)
Off-Topic: Optimal WebSTAR settings for WebDNA plugin v4.5 (2002)
WebDNA Solutions ... sorry! (1997)
Calendar (1997)
Multiple prices (1997)
Help Please WebDNA 6 Secure Forms Problem (2004)
Keep away (1997)
Using Plug-In while running 1.6.1 (1997)