Your results are consistent with your query, since you're sorting call_date in descending order (DESC). Change DESC to ASC (or remove it altogether and you should be fine.
On Thu, 17 Feb 2005 08:34:10 -0700, Paul Roe <[EMAIL PROTECTED]> 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195182 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
