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 = 52138
interpreted = N
texte = >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/
Associated Messages, from the most recent to the oldest:
>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/
Glenn Busbin
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:
It just Does't add up!!! (1997)
WebCat and AppleShare 6.0 (1998)
questions on variations of Ken's [text multi=T]var1=&var2=[/text] (1999)
[group] ? (1997)
Problems appending to database (1997)
File Uploads: WebCat/SiteEdit (1998)
Searching multiple Databases (1997)
[input] questions (1997)
Custom errormessages.db to intercept directory names (2002)
Can't Update records (1997)
& not allowed in db by definition? (1999)
problems with 2 tags (1997)
[addlineitems] display (1997)
Here's how to kill a Butler Database. (1997)
Many $WebCat.exe processes (1998)
many-to-one problem (1998)
Shopping Cart - prices? (1997)
Credit card types (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
WebCatalog NT beta 18 problem (1997)