Re: easy numfound search?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37040
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Clint Davis
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:
RAM variables (1997)
Bug? (1997)
[WebDNA] Search on a database (2012)
[WebDNA] WebDNA 7 fastcgi fails to start (2011)
Problems with date math (1997)
authenticating a second user (1997)
[WebDNA] Quick Date Question (2008)
Quick Question About Sorting (1997)
RE: How to verify email address (1997)
Triggers and today's leap day? (2000)
getting images' width/height (1998)
WebCatalog can't find database (1997)
Price characteristics? (1997)
Email (1998)
WC2.0 Memory Requirements (1997)
WebCatalog and Filemaker (1996)
[WebDNA] preventing hackers from posting their own (altered) version of my form? (2009)
How true is this? (1999)
problems with WebCat-Plugin (1997)
carriage returns in data (1997)