Re: [WebDNA] sum in a search
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103759
interpreted = N
texte = --Apple-Mail-54--388657286 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes There are four tags in that class - sum, avg, min and max. They are documented on the [search] context doc page: http://docs.webdna.us/pages.html?context=SearchContext.html They don't appear to be mentioned in the "searching" pages (as linked from the header nav bar). Brian Fries BrainScan Software On Oct 7, 2009, at 11:19 AM, Tana Adams wrote: > Yes, that's it...thanks, Dan. So I guess that's the only > command...for some reason, I guess I thought there was more to it. > > Thanks everyone! > > Tana > > > On Wed, Oct 7, 2009 at 11:09 AM, Dan Strong
> wrote: > [search db=your.db&eqYOURFIELDdata=whatever&YOURFIELDtype=num] > Sum = [sum field=YOURFIELD] > Qty = [numfound] > [/search] > > > -Dan Strong > http://www.DanStrong.com > > > Tana Adams wrote: > I know there's a way to calculate the sum and quantities within > [founditems] but I can't seem to locate it in the online reference. > Could someone please point me in the right direction? > > Thanks, > > Tana > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 > --Apple-Mail-54--388657286 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii There are four tags in that class - sum, avg, min and max. They are documented on the [search] context doc page:
They don't appear to be mentioned in the "searching" pages (as linked from the header nav bar).
Brian Fries
BrainScan Software
On Oct 7, 2009, at 11:19 AM, Tana Adams wrote:
Yes, that's it...thanks, Dan. So I guess that's the only command...for some reason, I guess I thought there was more to it.
Thanks everyone!
Tana
On Wed, Oct 7, 2009 at 11:09 AM, Dan Strong
<webdna@danstrong.com> wrote:
[search db=your.db&eqYOURFIELDdata=whatever&YOURFIELDtype=num]
Sum = [sum field=YOURFIELD]
Qty = [numfound]
[/search]
-Dan Strong
http://www.DanStrong.com Tana Adams wrote:
I know there's a way to calculate the sum and quantities within [founditems] but I can't seem to locate it in the online reference. Could someone please point me in the right direction?
Thanks,
Tana
--Apple-Mail-54--388657286 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes There are four tags in that class - sum, avg, min and max. They are documented on the [search] context doc page: http://docs.webdna.us/pages.html?context=SearchContext.html They don't appear to be mentioned in the "searching" pages (as linked from the header nav bar). Brian Fries BrainScan Software On Oct 7, 2009, at 11:19 AM, Tana Adams wrote: > Yes, that's it...thanks, Dan. So I guess that's the only > command...for some reason, I guess I thought there was more to it. > > Thanks everyone! > > Tana > > > On Wed, Oct 7, 2009 at 11:09 AM, Dan Strong > wrote: > [search db=your.db&eqYOURFIELDdata=whatever&YOURFIELDtype=num] > Sum = [sum field=YOURFIELD] > Qty = [numfound] > [/search] > > > -Dan Strong > http://www.DanStrong.com > > > Tana Adams wrote: > I know there's a way to calculate the sum and quantities within > [founditems] but I can't seem to locate it in the online reference. > Could someone please point me in the right direction? > > Thanks, > > Tana > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 > --Apple-Mail-54--388657286 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii There are four tags in that class - sum, avg, min and max. They are documented on the [search] context doc page:
They don't appear to be mentioned in the "searching" pages (as linked from the header nav bar).
Brian Fries
BrainScan Software
On Oct 7, 2009, at 11:19 AM, Tana Adams wrote:
Yes, that's it...thanks, Dan. So I guess that's the only command...for some reason, I guess I thought there was more to it.
Thanks everyone!
Tana
On Wed, Oct 7, 2009 at 11:09 AM, Dan Strong
<webdna@danstrong.com> wrote:
[search db=your.db&eqYOURFIELDdata=whatever&YOURFIELDtype=num]
Sum = [sum field=YOURFIELD]
Qty = [numfound]
[/search]
-Dan Strong
http://www.DanStrong.com Tana Adams wrote:
I know there's a way to calculate the sum and quantities within [founditems] but I can't seem to locate it in the online reference. Could someone please point me in the right direction?
Thanks,
Tana
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:
Announce: Bug fix talk list (1999)
Country & Ship-to address & other fields ? (1997)
[WebDNA] JSONStore Levels (2020)
Thanks Grant (1997)
user flush db (2002)
Execute Applescript (1997)
Searching multiple Databases (1997)
Not really WebCat (1997)
WebCommerce: Folder organization ? (1997)
b12 cannot limit records returned and more. (1997)
Time Remaining? (1998)
Options for http uploading of files (1999)
WebCat2 - Getting to the browser's username/password data (1997)
WebCatalog 4 Install Problems - Not Answered ?? (2000)
webcat- multiple selection in input field (1997)
[TaxableTotal] - not working with AOL and IE (1997)
WebCat2b15MacPlugin - [protect] (1997)
Upgrade to wsV (2004)
AE aware WebCatalog.acgi? (1997)
All questions are welcome on this list (1997)