What kind of field is "call_time" ... if it's a char/varchar field, you're SOL unless you convert it to a time field or use 24 hour time formatted HH:MM:SS...
Paul Roe wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195172 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
