Tim,
I have a page that lists job fairs with starting & end times (using the 12
hour format). A simple query does it for me:
<CFQUERY NAME="GETFAIRS" datasource="#dsn#">
SELECT *
FROM Jobfairs
WHERE EvtDate >= Now() -1
ORDER BY EvtDate, StartTime1, EndTime1
</CFQUERY>
Chris Montgomery [EMAIL PROTECTED]
Web Development & Consulting http://www.astutia.com
Allaire Sales & Consulting Partner
210-490-3249/888-745-7603 Fax 210-490-4692
Instant Messaging:
AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED]
> -----Original Message-----
> From: Tim [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 10, 2001 9:13 AM
>
> I have a conference database with a text field for
> time. The times are entered in 12 hour time with am
> or pm (ex., 9:00 am or 2:00 pm). Is there a way to
> sort this field to list the conferences in order by
> time?
<snip>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
