Ooops... I stand corrected. That idea is what I need, but I have to return EVERY row that has that date. There could be thousands of rows, and I need all of them.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 2:42 PM To: CF-Talk Subject: RE: Select MAX date from table BEAUTIFUL! That's exactly what I needed Michael. Thank you. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 31, 2006 2:33 PM To: CF-Talk Subject: Re: Select MAX date from table select cols from table limit 1 order by mydate desc (in other dbms this is select TOP 1 .... or select FIRST 1 .....) On 5/31/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > I've got a table that's going to have records spanning a whole week. > There's > a date field that I'm going to use as a filter to determine which records > to > display (the most recent). How might I query to get the records with the > most recent date only? > > I'd prefer to have just one query, but as I'm running mySQL 4.0.17 that > might not be possible. This means I can't perform subqueries. > > so my records might be like this: > > 2006-05-31 creole 15 > 2006-05-31 andy 78 > 2006-05-30 creole 12 > 2006-05-30 andy 76 > > If I was adding in the data manually there would be no issue with what to > grab, but the question is further complicated by the data import that I'll > be performing once per day around 2am. This site is going to be used by > people internationally so I can never be sure WHAT day the person will > have. > > So, if I suppose that I could do a query to get the MAX(date) from the > table, then a second query upon that value. But I'd love to see if there's > a > better way first. > > Anyone? > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241863 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
