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 = 52129
interpreted = N
texte = I have been looking into index searching alot lately. It may not be exactlywhat you want, but it may be along the right premise to getting what youneed.Add an additional field to the DB or make a new DB that is associated withthe main topic ID and it will contain a number. Starting out with 0 and thenincrease by one everytime someone post a reply to it.This would allow you to show the number of replies to a specific postwithout having to search and sum.Is this possible for you?----- Original Message ----- From: "Robert Wade"
To: "WebDNA Talk" Sent: Friday, August 08, 2003 10:12 AMSubject: Re: Sorting by highest number of matches unique to a field> Kenneth, Thanks. I just tried a slimmed down search with no sort> specified...>> [search db=db/messages.db&nemsg_iddatarq=[blank]&msg_idsumm=T&max=10]> [founditems]> ...> [/founditems]> [/search]>> What you are saying, is that this would list the [msg_id] at the top> that had the most matches? It didn't.>> this search seemed to randomly, pick out 10 results. I could not find> a pattern to the sort at all. It just grabbed 10 of them out of> seemingly anywhere in the db., of those the highest number was 10> matches. I know that one [msg_id] in particular has over 200 posts,> and there are many that have more than 10.>> I thought that the default sort was "best match" not "most matches" In> otherwords the results that "best match" the search criteria, not the> results that have the most matches...?>> -- Confused.>>> On Friday, August 8, 2003, at 11:27 AM, Kenneth Grome wrote:>> >> I was hoping to get a clearer understanding of the possibility of> >> sorting a search by entries that have the most number of matches> >> first.> >> >> > WebDNA automatically sorts by placing the records with the most> > matches at the top of the founditems list. If you use sort parameters> > you will override this automatic ranking of the entire founditems> > list, but ranking will still occur within the groups you are sorting> > by -- unless you put "&allhit=1" into your search parameters which> > will effectively turn off all automatic ranking.> >> > -- > >> > Sincerely,> > Kenneth Grome> > -------------------------------------------------------------> > Outsource your WebDNA programming for $18 an hour or less!> > -------------------------------------------------------------> >> > -------------------------------------------------------------> > 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/-------------------------------------------------------------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 have been looking into index searching alot lately. It may not be exactlywhat you want, but it may be along the right premise to getting what youneed.Add an additional field to the DB or make a new DB that is associated withthe main topic ID and it will contain a number. Starting out with 0 and thenincrease by one everytime someone post a reply to it.This would allow you to show the number of replies to a specific postwithout having to search and sum.Is this possible for you?----- Original Message ----- From: "Robert Wade" To: "WebDNA Talk" Sent: Friday, August 08, 2003 10:12 AMSubject: Re: Sorting by highest number of matches unique to a field> Kenneth, Thanks. I just tried a slimmed down search with no sort> specified...>> [search db=db/messages.db&nemsg_iddatarq=[blank]&msg_idsumm=T&max=10]> [founditems]> ...> [/founditems]> [/search]>> What you are saying, is that this would list the [msg_id] at the top> that had the most matches? It didn't.>> this search seemed to randomly, pick out 10 results. I could not find> a pattern to the sort at all. It just grabbed 10 of them out of> seemingly anywhere in the db., of those the highest number was 10> matches. I know that one [msg_id] in particular has over 200 posts,> and there are many that have more than 10.>> I thought that the default sort was "best match" not "most matches" In> otherwords the results that "best match" the search criteria, not the> results that have the most matches...?>> -- Confused.>>> On Friday, August 8, 2003, at 11:27 AM, Kenneth Grome wrote:>> >> I was hoping to get a clearer understanding of the possibility of> >> sorting a search by entries that have the most number of matches> >> first.> >> >> > WebDNA automatically sorts by placing the records with the most> > matches at the top of the founditems list. If you use sort parameters> > you will override this automatic ranking of the entire founditems> > list, but ranking will still occur within the groups you are sorting> > by -- unless you put "&allhit=1" into your search parameters which> > will effectively turn off all automatic ranking.> >> > -- > >> > Sincerely,> > Kenneth Grome> > -------------------------------------------------------------> > Outsource your WebDNA programming for $18 an hour or less!> > -------------------------------------------------------------> >> > -------------------------------------------------------------> > 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/-------------------------------------------------------------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/
"WebDna @"
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:
Different Drive (2003)
Multiple prices (1997)
.. more on sliding discounts... (1997)
ThreadMem ignored? (1998)
Fun with Dates - finally resolved but.... (1997)
Images in WebCat (2000)
frames & carts (1997)
Works! (1997)
docs for WebCatalog2 (1997)
webcatalog for linux (1998)
Setting a text Var inside an orderfile (2002)
Duplicates (1998)
apparent variable variable display? (2000)
Encrypt Decrypt URL UnURL Weirdness (2001)
[OT] Help Webcat 213 win (2000)
Multi-processor Mac info ... (1997)
suffix mapping, use of cache, etc. (1997)
multi-paragraph fields (1997)
Emailer help....! (1997)
Updating Prices in Online Database (1999)