Re: easy numfound search?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37042
interpreted = N
texte = Actually, I encountered something similar and solved it by assigning numbersto the options (in the DB). The when you code the page resolve the numberswith the option.So, fish would be saved as a 1, and green would be saved as a 2. The justsort numerically and Fish will always list first.-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Clint DavisSent: Monday, July 09, 2001 12:55 PMTo: WebCatalog TalkSubject: Re: easy numfound search?The easiest that I know of would be like this:[search db=MY.db&neSOMEFIELDdata=find_all] [founditems] [showif [SOMEFIELD]=fish] [SOMEFIELD] [/showif] [showif [SOMEFIELD]=green] [SOMEFIELD] [/showif] [showif [SOMEFIELD]=bottle] [SOMEFIELD] [/showif] [/founditems][/search]>uhm.. not exactly. i have many records whose value is fish. and i>have not so many records whose value is green and not so many whose>value is bottle. i want fish to appear at the top of my list>before green and bottle>>>John Peacock wrote:>>>Celeste Paul wrote:>>>>>hi, does anyone have any good ideas on how i could sort a list based on>>>a found items?>>>>>>i have a db that i do i search on a phrase to get the number of>>>occurances. i would like to sort this list with the most occuring near>>>the top. right now im writing a new db with a hard coded>>>number-of-items (changes with each replace/append) and then populating a>>>list. i feel its unneeded to have two dbs.. but couldnt think of>>>another way to approach the problem. i also need to keep the base raw>>>db with each individual record because it stores the date and time of>>>each entry>>>>>>>I'm not completely sure what you are asking but let me take a shot at>>an example and you tell me whether that is what you meant:>>>>You want to search a field for the word fish and return the record>>with the most instances of fish first, and so on down the line.>>>>If so, then you are in luck; WebCat does this automatically! When>>you do a search in WebCat without requesting a specific sorting>>sequence, WC uses an internal fitness algorythm which orders the>>records from best to worst.>>>>HTH>>>>John>>>>-->>John Peacock>>Director of Information Research and Technology>>Rowman & Littlefield Publishing Group>>4720 Boston Way>>Lanham, MD 20706>>301-459-3366 x.5010>>fax 301-429-5747>>>>------------------------------------------------------------->>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/>>>>>>>------------------------------------------------------------->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/--_______________________Clint DavisWebmasterGray Loon Marketing Group812.422.9999cdavis@grayloon.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 toWeb Archive of this list is at: http://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Actually, I encountered something similar and solved it by assigning numbersto the options (in the DB). The when you code the page resolve the numberswith the option.So, fish would be saved as a 1, and green would be saved as a 2. The justsort numerically and Fish will always list first.-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Clint DavisSent: Monday, July 09, 2001 12:55 PMTo: WebCatalog TalkSubject: Re: easy numfound search?The easiest that I know of would be like this:[search db=MY.db&neSOMEFIELDdata=find_all] [founditems] [showif [SOMEFIELD]=fish] [SOMEFIELD] [/showif] [showif [SOMEFIELD]=green] [SOMEFIELD] [/showif] [showif [SOMEFIELD]=bottle] [SOMEFIELD] [/showif] [/founditems][/search]>uhm.. not exactly. i have many records whose value is fish. and i>have not so many records whose value is green and not so many whose>value is bottle. i want fish to appear at the top of my list>before green and bottle>>>John Peacock wrote:>>>Celeste Paul wrote:>>>>>hi, does anyone have any good ideas on how i could sort a list based on>>>a found items?>>>>>>i have a db that i do i search on a phrase to get the number of>>>occurances. i would like to sort this list with the most occuring near>>>the top. right now im writing a new db with a hard coded>>>number-of-items (changes with each replace/append) and then populating a>>>list. i feel its unneeded to have two dbs.. but couldnt think of>>>another way to approach the problem. i also need to keep the base raw>>>db with each individual record because it stores the date and time of>>>each entry>>>>>>>I'm not completely sure what you are asking but let me take a shot at>>an example and you tell me whether that is what you meant:>>>>You want to search a field for the word fish and return the record>>with the most instances of fish first, and so on down the line.>>>>If so, then you are in luck; WebCat does this automatically! When>>you do a search in WebCat without requesting a specific sorting>>sequence, WC uses an internal fitness algorythm which orders the>>records from best to worst.>>>>HTH>>>>John>>>>-->>John Peacock>>Director of Information Research and Technology>>Rowman & Littlefield Publishing Group>>4720 Boston Way>>Lanham, MD 20706>>301-459-3366 x.5010>>fax 301-429-5747>>>>------------------------------------------------------------->>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/>>>>>>>------------------------------------------------------------->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/--_______________________Clint DavisWebmasterGray Loon Marketing Group812.422.9999cdavis@grayloon.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 toWeb Archive of this list is at: http://search.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://search.smithmicro.com/
Tad
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:
AOL (1999)
Checking whether remote image exists? (2004)
process SSI (1998)
Grouping Fields in Context (1999)
[math] with first letter in field? (1997)
Word search (1997)
More on the email templates (1997)
WC2.0 Memory Requirements (1997)
Stopping bad HTML propagation ? (1997)
WebCat2: multiple currency support (1997)
Showif = stumped? (2001)
multiple search commands (1997)
Payflow Pro on OSX (2003)
[OT] MacOs IE5 topmargin and leftmargin bug (2000)
Refreshing Javascript (2001)
show if date < expiry date (small corrections) (2002)
Sendmail truncation in Eudora Clients (1998)
OT: Just for a waste of time (2003)
Rounding problem (1998)
Setting up WebCatalog with Retail Pro data (1996)