Searching a field and returning the highest value

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14441
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 asfsadfafassfdfrom this list i would want find the highest value in the field value i.e. 99Hope all of this makes sense.Thanks, Ben Warren ---------------------------------------------------------------------------- Ben@anu.net (Ben Warren) ---------------------------------------------------------------------------- ANU Internet Services, James St, Westport, Co. Mayo, Ireland ---------------------------------------------------------------------------- http://www.anu.ie/ ---------------------------------------------------------------------------- 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 asfsadfafassfdfrom this list i would want find the highest value in the field value i.e. 99Hope all of this makes sense.Thanks, Ben Warren ---------------------------------------------------------------------------- Ben@anu.net (Ben Warren) ---------------------------------------------------------------------------- ANU Internet Services, James St, Westport, Co. Mayo, Ireland ---------------------------------------------------------------------------- http://www.anu.ie/ ---------------------------------------------------------------------------- Ben Warren

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:

RE: Formulas.db + Users.db (1997) WebCatalog vs. Cold Fusion (1998) Re:Can this be done? (1997) WebCatalog NT (1996) Duplicate Messages (1998) Not really WebCat (1997) # fields limited? (1997) Quick poll (2003) [WebDNA] php/mySQL version of WebDNA Speed Test? (2009) Selling WebDNA as a solution (2003) WebCatalog/WebMerchant 2.1 (1998) credit card (1997) Catalogs and W* (1996) [shownext max=?] armed (1997) [WebDNA] Sorry WebDNA server not running (2014) Displaying photo attached to first record (1997) Founditems context returning only 1 item (1997) WebDNA Windows 5.0 sendmail bug (2003) Group Updates (1998) Maybe off topic but how to charge (1997)