Re: &summ=T >> numfound

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45353
interpreted = N
texte = Ahh, I see, this would be usefull. As of now it requires a small bit of code.Ya know, Things like this need to make it to a list somewhere's. :-)I know there has been a lot of good ideas that just get buried in the talk list archives.DonovanAlain Russell wrote:> No, that gives me the sum of the field. So for instance if your database > contained 3 records and the field 'soup' contained 12,18 &11 [sum > field=soup] would give you 41. > > I am looking for a way to know how many items of each were in a field when > the search contains a FIELDsumm=T > > Some.db > ----------------- > can soup > 1 a > 2 b > 3 c > 4 c > 5 a > 6 a > 7 b > 8 c > 9 c > > Then my search > [search db=some.db&neCANdata=find_all&SOUPsumm=T] > > This will find 3 things a,b,c. I want to know how many a's, how many b,s and > how many c's there were when the engine 'summed' them .. > > So if I did: > [founditems] > [soup]: [sumnumfound]
> [/founditems] > > I would get: > a: 3 > b: 2 > c: 4 > > Hope that is clearer. > Alain ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
Ahh, I see, this would be usefull. As of now it requires a small bit of code.Ya know, Things like this need to make it to a list somewhere's. :-)I know there has been a lot of good ideas that just get buried in the Talk List archives.DonovanAlain Russell wrote:> No, that gives me the sum of the field. So for instance if your database > contained 3 records and the field 'soup' contained 12,18 &11 [sum > field=soup] would give you 41. > > I am looking for a way to know how many items of each were in a field when > the search contains a FIELDsumm=T > > Some.db > ----------------- > can soup > 1 a > 2 b > 3 c > 4 c > 5 a > 6 a > 7 b > 8 c > 9 c > > Then my search > [search db=some.db&neCANdata=find_all&SOUPsumm=T] > > This will find 3 things a,b,c. I want to know how many a's, how many b,s and > how many c's there were when the engine 'summed' them .. > > So if I did: > [founditems] > [soup]: [sumnumfound]
> [/founditems] > > I would get: > a: 3 > b: 2 > c: 4 > > Hope that is clearer. > Alain ------------------------------------------------------------- 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://search.smithmicro.com/ Donovan Brooke

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:

Server Freeze (1998) [WebDNA] Search/sort/summ problem (2010) [SearchString] problem with [search] context (1997) Not really WebCat (1997) Nested tags count question (1997) WebDNA and WebSTAR Error pages II (2004) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) Emailer setup (1997) Emailer (WebCat2) (1997) remotely add + sign (1997) Quit revisited (1997) ATTN:SMITH MICRO (2001) Mac: [ListFiles] bug alert (1997) using listfiles to build a database? more (2000) server not running. (2003) Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) [shell] stopped ?? (2003) For those of you not on the WebCatalog Beta... (1997) Can ShowNext do this? (2000) [ot] Still Interested In Acquiring Hosting Companies (2006)