I know I have done this in the past, but I cannot figure it out for some reason.
I want to grab out of a database the record with the highest value for the field RATING (it is an INT). I also want to grab all the data for the record like Image1, Description etc.... SELECT MAX(RATING), Image1, Description FROM cars WHERE approved = 1 Something is very wrong with my select statement.. I cant figure out if I have to do a MAX(RATING) AS MaximumRATING, Image1, Description... Need more coffee! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
