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:

[WebDNA] passing a variable in an include - precedence (2015) emailer w/F2 (1997) [WebDNA] showif/sendmail question (2008) [WebDNA] Shopping cart code debug (2009) WebCatalog can't find database (1997) [WebDNA] Help with iTools 9/WebDNA setup MacTel (2009) Cookie set browser session. (1998) Help! WebCat2 bug (1997) Exclamation point (1997) Pgp&emailer (1997) Cookies and WebCat?? (1999) Shipping Via Actual UPS/FEDEX Zones (1999) Searching for the end (1998) 2.0 Info (1997) Locking up with WebCatalog... (1997) [OT] Change permissions via FTP? (2002) [WebDNA] Chatroom with Webcatalog (2011) expired beta (1997) Sendmail doesn't (was Queertrons?) (1997) syntax question, not in online refernce (1997)