Re: [WebDNA] sum in a search
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103760
interpreted = N
texte = --0015175ce068e23fd904755d9bb6Content-Type: text/plain; charset=ISO-8859-1That's it! Yes, I was clicking on the 'searching' link at the top of theresources page and couldn't locate it. Didn't occur to me to look up theactual search context.Thanks, Brian!TanaOn Wed, Oct 7, 2009 at 12:32 PM, Brian Fries
wrote:> 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>>>>>--0015175ce068e23fd904755d9bb6Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: quoted-printableThat's it!=A0 Yes, I was clicking on the 'searching' link at th=e top of the resources page and couldn't locate it.=A0 Didn't occur= to me to look up the actual search context.
Thanks, Brian!
T=ana
On Wed, Oct 7, 2009 at 12:32 PM, Brian F=ries
<dna=@brainscansoftware.com> wrote:
There are four tags in that class - sum, avg, min and max. =They are documented on the [search] context =A0doc 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.=A0 So I guess that=39;s the only command...for some reason, I guess I thought there was more t=o it.
Thanks everyone!
Tana
On W=ed, Oct 7, 2009 at 11:09 AM, Dan Strong
<webdna@danstrong.com>=span> wrote:
[search db=3Dyour=.db&eqYOURFIELDdata=3Dwhatever&YOURFIELDtype=3Dnum]
Sum =3D [sum field=3DYOURFIELD]
Qty =3D [numfound]
[/search]
-Dan Strong
http://www.DanStron=g.comTana Adams wrote:
I know there's a way to calculate the sum and quantities within [foundi=tems] but I can't seem to locate it in the online reference. =A0Could s=omeone please point me in the right direction?
Thanks,
Tana
--0015175ce068e23fd904755d9bb6--
Associated Messages, from the most recent to the oldest:
--0015175ce068e23fd904755d9bb6Content-Type: text/plain; charset=ISO-8859-1That's it! Yes, I was clicking on the 'searching' link at the top of theresources page and couldn't locate it. Didn't occur to me to look up theactual search context.Thanks, Brian!TanaOn Wed, Oct 7, 2009 at 12:32 PM, Brian Fries wrote:> 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>>>>>--0015175ce068e23fd904755d9bb6Content-Type: text/html; charset=ISO-8859-1Content-Transfer-Encoding: quoted-printableThat's it!=A0 Yes, I was clicking on the 'searching' link at th=e top of the resources page and couldn't locate it.=A0 Didn't occur= to me to look up the actual search context.
Thanks, Brian!
T=ana
On Wed, Oct 7, 2009 at 12:32 PM, Brian F=ries
<dna=@brainscansoftware.com> wrote:
There are four tags in that class - sum, avg, min and max. =They are documented on the
[search] context =A0doc 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.=A0 So I guess that=39;s the only command...for some reason, I guess I thought there was more t=o it.
Thanks everyone!
Tana
On W=ed, Oct 7, 2009 at 11:09 AM, Dan Strong
<webdna@danstrong.com>=span> wrote:
[search db=3Dyour=.db&eqYOURFIELDdata=3Dwhatever&YOURFIELDtype=3Dnum]
Sum =3D [sum field=3DYOURFIELD]
Qty =3D [numfound]
[/search]
-Dan Strong
http://www.DanStron=g.comTana Adams wrote:
I know there's a way to calculate the sum and quantities within [foundi=tems] but I can't seem to locate it in the online reference. =A0Could s=omeone please point me in the right direction?
Thanks,
Tana
--0015175ce068e23fd904755d9bb6--
Tana Adams
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:
carriage returns in data (1997)
Web Site (2000)
Setting variables. (1998)
counting characters and/or words (1997)
Setting up a lightbox (2002)
select multiple (1997)
Running 2 two WebCatalog.acgi's (1996)
Sku numbers (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
[addlineitems] (1997)
wee problem (2001)
RE: Automatic thumbnail images (1998)
CAPTCHA system in webDNA (2005)
[WebDNA] how to purge webdna cache of templates? (2009)
Sendmail truncation in Eudora Clients (1998)
password authentication schemes (2003)
in conversions.db crashes unix webcat (1999)
OT: Weird table rendering w/ WebCat in Explorer (2005)
[BULK] [WebDNA] [BULK] WebDNA 7 - Showing every other far DB - Fault! (2011)
WebCat2 - [format thousands] (1997)