I still think if you have the query already, query of query it. Adrian.
-----Original Message----- From: Scott Stewart Sent: 15 February 2008 14:11 To: CF-Talk Subject: RE: Last Updated It's MSSQLServer.. this should work Thanks all :) sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -----Original Message----- From: Sonny Savage Sent: Friday, February 15, 2008 8:47 AM To: CF-Talk Subject: Re: Last Updated The solution varies by database, which one are you using? This would would work on MSSQL SELECT TOP 1 * FROM your_table_name ORDER BY updated_date DESC On Fri, Feb 15, 2008 at 8:40 AM, Scott Stewart <[EMAIL PROTECTED]> wrote: > Hey all, > > > > I have a query that returns a list of dates, how would I find the most > recent. to post as "Last Updated" > > > > Thanks > > > > sas > > > > -- > > Scott Stewart ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4