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:

Slow Code, how to speed up (2002) [WebDNA] 404 Pages (2014) Options for http uploading of files (1999) Web Catalog 2 demo (1997) [WebDNA] grep again (2010) web delivery (1997) XML Woes [Hijacked Thread] (2004) [browsername] not working? (1997) Emailer again (1997) Search multiple fields (1997) WebCat Slowdown (2000) WebCat2b13MacPlugIn - More limits on [include] (1997) WebCat2b15MacPlugin - showing [math] (1997) OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998) [WebDNA] New Server Setup (2016) WebCat2 beta 11 - new prefs ... (1997) WebDNA Solutions ... sorry! (1997) [WebDNA] Multi Part SendMail (2013) Templates for Customer Database? (1997) Sort Order on a page search (1997)