Re: [WebDNA] sum in a search

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103760
interpreted = N
texte = --0015175ce068e23fd904755d9bb6 Content-Type: text/plain; charset=ISO-8859-1 That's it! Yes, I was clicking on the 'searching' link at the top of the resources page and couldn't locate it. Didn't occur to me to look up the actual search context. Thanks, Brian! Tana On 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 >> > > > --0015175ce068e23fd904755d9bb6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable That'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:

http://docs.webdna.us/pages.html?context=3DSearchContext.= 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.=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> wrote:
[search db=3Dyour= .db&eqYOURFIELDdata=3Dwhatever&YOURFIELDtype=3Dnum]
Sum =3D [sum field=3DYOURFIELD]
Qty =3D [numfound]
[/search]


-Dan Strong
http://www.DanStron= g.com


Tana 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
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288



--0015175ce068e23fd904755d9bb6-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] sum in a search (Stuart Tremain 2009)
  2. Re: [WebDNA] sum in a search ("Terry Wilson" 2009)
  3. Re: [WebDNA] sum in a search (Govinda 2009)
  4. Re: [WebDNA] sum in a search (Tana Adams 2009)
  5. Re: [WebDNA] sum in a search (Brian Fries 2009)
  6. Re: [WebDNA] sum in a search (Tana Adams 2009)
  7. Re: [WebDNA] sum in a search (Tana Adams 2009)
  8. Re: [WebDNA] sum in a search (Dan Strong 2009)
  9. Re: [WebDNA] sum in a search (Kenneth Grome 2009)
  10. Re: [WebDNA] sum in a search ("Terry Wilson" 2009)
  11. [WebDNA] sum in a search (Tana Adams 2009)
--0015175ce068e23fd904755d9bb6 Content-Type: text/plain; charset=ISO-8859-1 That's it! Yes, I was clicking on the 'searching' link at the top of the resources page and couldn't locate it. Didn't occur to me to look up the actual search context. Thanks, Brian! Tana On 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 >> > > > --0015175ce068e23fd904755d9bb6 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable That'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:

http://docs.webdna.us/pages.html?context=3DSearchContext.= 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.=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> wrote:
[search db=3Dyour= .db&eqYOURFIELDdata=3Dwhatever&YOURFIELDtype=3Dnum]
Sum =3D [sum field=3DYOURFIELD]
Qty =3D [numfound]
[/search]


-Dan Strong
http://www.DanStron= g.com


Tana 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
---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
old archives: http://dev.webdna.us/TalkListArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?pa= ge=3Dtopics&category=3D288



--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)