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 numbers to the options (in the DB). The when you code the page resolve the numbers with the option.So, fish would be saved as a 1, and green would be saved as a 2. The just sort numerically and Fish will always list first.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Clint Davis Sent: Monday, July 09, 2001 12:55 PM To: WebCatalog Talk Subject: 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 Davis Webmaster Gray Loon Marketing Group 812.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 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/
Associated Messages, from the most recent to the oldest:
Actually, I encountered something similar and solved it by assigning numbers to the options (in the DB). The when you code the page resolve the numbers with the option.So, fish would be saved as a 1, and green would be saved as a 2. The just sort numerically and Fish will always list first.-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Clint Davis Sent: Monday, July 09, 2001 12:55 PM To: WebCatalog Talk Subject: 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 Davis Webmaster Gray Loon Marketing Group 812.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 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/
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:
authenticating a second user, the sequel (1997)
Help! WebCat2 bug (1997)
Erotic Sites (1997)
HELP (2000)
RequiredFields template (1997)
List Name Change (2002)
carriage returns in data (1997)
database size? (1997)
[shownext] not displaying anything but first indices found (2000)
db security on NT (1997)
Running _every_ page through WebCat-error.html (1997)
New commands in Final candidate (1997)
question: writing files textb in webmerch (1997)
WebDNA 6 (2004)
Separate SSL Server (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
SQL Error (2007)
Nested tags count question (1997)
RE: [WebDNA] Cheers (2008)
Looking up two prices in Formulas.db (1997)