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) SendTo more emails (1998) OT: [WAY IN RIGHT FIELD SOMEWHERE] Spam Filters (2005) I give up!! (1997) no template caching (1997) Hello??? (1997) popups, netscape vs explorer (1997) problems with 2 tags (1997) Multiple prices (1997) Rumpus/Typhoon modules included in Typhoon ... (1997) BR (1997) f2 download problems (1997) [WriteFile] problems (1997) Re:need help please (1997) typhoon... (1997) inetinfo.exe (1999) random in arizona (2003) Webstar 1.3.1 PPC (1997) suggestion (1997) [WebDNA] generic Ajax question: storing a variable site-wide (2009)