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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching a field and returning the highest value (Grant Hulbert 1997)
  2. Re: Searching a field and returning the highest value (Kenneth Grome 1997)
  3. Searching a field and returning the highest value (Ben Warren 1997)
>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 | Typhoon 619/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)