<CFQUERY name="GetSchedule" datasource="#Datasource#">
SELECT * FROM schedule ORDER BY 'eventdate'
</CFQUERY>
But using above query with (order by) is producing this output
Monday, September 20, 2004
Wednesday, July 7, 2004
Sunday, April 18, 2004
Wednesday, May 12, 2004