Re: Sorting by highest number of matches unique to a field

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52140
interpreted = N
texte = I've just seen the end of this thread and have always wanted a [summnumfound] when searching and doing a summ=T Seems this would help a lot in this situation as well .. ? So [search db=mydb.db&neFIELDdata=find_all&FIELDsumm=T] [founditems] [field] : [sumnumfound] [/founditems] [/search] This would be quite easy to resort this data without a whole lot more nested searches .. Alain >> Glenn, thanks, but that won't work for my situation. It still doesn't put >> the highest number of results in order. The example you provided would sort >> the results of each group. I need a listing of summarized groups with the >> most per group listed first. (god, I'm confusing myself now). Besides, >> you're talking about nesting about 3,000 searches there. Yikes. >> > > If you can't find a code solution to solve your problem, you have a serious > problem with the data being used. > > Your options are > 1- Write code to sort the existing data as you want, even if it requires more > than one search > 2- Revise the db to include a field that contains data that will let you sort > as you want > 3- Write a new db that keeps metadata about the existing db that can be sorted > as you want. > > Pick one and go for it. > > Glenn > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting by highest number of matches unique to a field ( Alain Russell 2003)
  2. Re: Sorting by highest number of matches unique to a field ( Glenn Busbin 2003)
  3. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  4. Re: Sorting by highest number of matches unique to a field ( Glenn Busbin 2003)
  5. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  6. Re: Sorting by highest number of matches unique to a field ( Brian Fries 2003)
  7. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  8. Re: Sorting by highest number of matches unique to a field ( "WebDna @" 2003)
  9. Re: Sorting by highest number of matches unique to a field ( Robert Wade 2003)
  10. Re: Sorting by highest number of matches unique to a field ( Kenneth Grome 2003)
  11. Sorting by highest number of matches unique to a field ( Robert Wade 2003)
I've just seen the end of this thread and have always wanted a [summnumfound] when searching and doing a summ=T Seems this would help a lot in this situation as well .. ? So [search db=mydb.db&neFIELDdata=find_all&FIELDsumm=T] [founditems] [field] : [sumnumfound] [/founditems] [/search] This would be quite easy to resort this data without a whole lot more nested searches .. Alain >> Glenn, thanks, but that won't work for my situation. It still doesn't put >> the highest number of results in order. The example you provided would sort >> the results of each group. I need a listing of summarized groups with the >> most per group listed first. (god, I'm confusing myself now). Besides, >> you're talking about nesting about 3,000 searches there. Yikes. >> > > If you can't find a code solution to solve your problem, you have a serious > problem with the data being used. > > Your options are > 1- Write code to sort the existing data as you want, even if it requires more > than one search > 2- Revise the db to include a field that contains data that will let you sort > as you want > 3- Write a new db that keeps metadata about the existing db that can be sorted > as you want. > > Pick one and go for it. > > Glenn > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > ------------------------------------------------------------- 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://webdna.smithmicro.com/ Alain Russell

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:

Updating a database once per day - An example (1998) Attn: Bug in GeneralStore example b15 (1997) WebCat2 - [format thousands] (1997) WebCat2 Append problem (B14Macacgi) (1997) emailer error -108 (1997) WebCat2_Mac RETURNs in .db (1997) Max Record length (1997) [WebDNA] MAX Date (2018) PCS Frames (1997) Time Display from Database (1997) WebCat2final1 crashes (1997) WebCat/CyberStudio Compatibility (1998) [TIME] not working (2007) shipcost (1997) email code (1998) Fun with dates (1997) Searching/sorting dates (1997) Great product and great job ! (1997) [OT] How'd it go, Sal? (2006) Out of the woodwork (2007)