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:

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)