Hey I'm having a problem I have data in a table that looks like this Call_Date 2005-02-16 00:00:00
Call_Time 7:53:00 Right now I am trying to sort the records so that I get the most recent 5. Here's my qoq: SELECT * FROM getMemberActivity ORDER BY call_date DESC,call_time DESC This returns data that looks like this : 2005-02-16 00:00:00 9:38:00 2005-02-16 00:00:00 8:55:00 2005-02-16 00:00:00 8:34:00 2005-02-16 00:00:00 8:05:00 2005-02-16 00:00:00 8:04:00 2005-02-16 00:00:00 7:53:00 2004-12-16 00:00:00 15:28:00 When what I want is this: 2004-12-16 00:00:00 15:28:00 2005-02-16 00:00:00 9:38:00 2005-02-16 00:00:00 8:55:00 2005-02-16 00:00:00 8:34:00 2005-02-16 00:00:00 8:05:00 2005-02-16 00:00:00 8:04:00 2005-02-16 00:00:00 7:53:00 Any ideas, I'm running cf 5.0 on windowsiis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195170 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
