On Fri, Jul 24, 2009 at 7:17 PM, Judah McAuley <ju...@wiredotter.com> wrote:
> SELECT TOP 1 id, approved, date > FROM mytable > WHERE date > ( > SELECT MAX(date) FROM mytable WHERE approved = 0 > ) > ORDER BY date DESC > Yeah... Thanks this is what I was looking for... Thanks Judah. I knew it was in there somewhere... will check into that monday -- Casey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4