Re: Searching a field and returning the highest value
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14561
interpreted = N
texte = >I want to be able to earch through one of the fields (numeric) in a databse>find all the records which have a value in this field and then display the>higest value in the field e.g.>>no. value text>1 10 gvsdf>2 3 afsdfasdf>3 sdfsaf >4 6 safddf>5 99 asfsadfafassfd[search db=xx.db&neVALUEdata=[blank]&deVALUEsort=1&max=1][FoundItems] [no.], [value], [text][/FoundItems][/search]This sirt sin descending order by value and displays only the top 1 (max=1).Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I want to be able to earch through one of the fields (numeric) in a databse>find all the records which have a value in this field and then display the>higest value in the field e.g.>>no. value text>1 10 gvsdf>2 3 afsdfasdf>3 sdfsaf >4 6 safddf>5 99 asfsadfafassfd[search db=xx.db&neVALUEdata=[blank]&deVALUEsort=1&max=1]
[founditems] [no.], [value],
[text][/FoundItems][/search]This sirt sin descending order by value and displays only the top 1 (max=1).Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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:
Trigger: executes every N days (2001)
PCS Emailer's role ? (1997)
REPLACE & MAX/STARTAT parameters doesn't work? (2000)
webcat running as www, should that be webstar for use with (2002)
Linux WebCatalog on Apache w/ Raven SSL (2000)
Confirming a bug/oddity (2003)
[WebDNA] Still having problems (2008)
Sorting LISTFILES (1997)
two unique banners on one page (1997)
A Function question... about remembering (2004)
E-mail formating question (1999)
Multi-processor Mac info ... (1997)
using showpage and showcart commands (1996)
Db design question (relational vs. flat?) (1998)
Feature req. (2002)
sorting... (2003)
OK, here goes... (1997)
Separate SSL Server (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
[searchString] (1997)