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:

WebCat2b13MacPlugIn - [showif][search][/showif] (1997) BUG in [showif] using ^ (contains) (1997) Frames and WebCat (1997) FEATURE REQUEST: (was: Summarizing results. Is there a (1999) Bug Report, maybe (1997) notification solutions (1997) access denied problem (1997) Auto Delete EmailCompleted Files (2002) Looking up two prices in database? (1997) webcat license???? (1997) ShipCost Data Base (1998) Virtual hosting and webcatNT (1997) & not allowed in db by definition? (1999) [WebDNA] Limts? -and- Hot Merge (2009) RE: [sendmail]- bcc? (1998) [WebDNA] Variable mystery (2009) Country & Ship-to address & other fields ? (1997) Help! WebCat2 bug (1997) Details of shipping - Totalqty calculations (1997) [Reload mydata.db] (1998)