3/15/2004 01:25:54
or is it like
3/15/2004 00:00:00
if its like the first one, it should already be ordering by that...if its
not...
then you will have to start writing the datetime combo to the field...make
sense?
or if you have a date field, and a time field, separate from each other, you
can
just put them both in the order by clause:
order by date, time desc
hth
tony
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 9:40 AM
To: CF-Talk
Subject: Order by date and then time
I would like to order first by datechanged and then by the time it was
changed. I have so far this code:
<CFQUERY name="logdata" datasource="wweb_status"> Select * from statuslog
Order by datechanged desc </CFQUERY>
It orders correctly by date changed. For example, if multiple changes were
made today, 3/15/2004, how do I then tell it to order by the time to the
very first item?
Thanks.
Robert
HWW
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
