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:
Bug Report, maybe (1997)
Selected Item in Pop-down (2003)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
Bug? (1997)
Announce: Bug fix talk list (1999)
RE: Writefile outside WebSTAR hierarchy? (1997)
more info on [setlineitems] (1997)
Separate SSL Server (1997)
Searching Relational Databases (2004)
CommandSecurity? (1997)
A few questions. . . (1997)
Anyone awake? Newby moves deeper! Sitesearch & (2000)
Some Questions (1997)
Help name our technology! (1997)
unusual search problem (1998)
WC2b12: Yes, Formulas.db is for real (1997)
Running _every_ page through WebCat-error.html (1997)
New site announcement + Showing once on a founditems (1997)
no global [username] or [password] displayed ... (1997)
WebCatalog and directory indexing (1998)