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=TSeems 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 nestedsearches .. 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:
I've just seen the end of this thread and have always wanted a[summnumfound] when searching and doing a summ=TSeems 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 nestedsearches .. 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:
DON'T use old cart file! (1997)
database files in secure folder (1997)
CloseDatabase (1997)
Webcatalog acgi conflict? (1999)
The Form authentication trick (2000)
Close-to Comparison Code (1998)
Any problems with Welcome & WebCat? (2000)
Emailer (1997)
Logout? (1998)
[WebDNA] Authentication (2009)
prefs file not being written to (2000)
Sorting (1998)
WebCommerce: Folder organization ? (1997)
Re:listfiles-looking for slick solution (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
NTbeta18 corrupted? (1997)
Migrating to NT -Reply (1997)
A quickie question (1997)
Size limit for tmpl editor ? (1997)
paymethod=cc allows all zeros (1999)