6 :
7 : <CFQUERY DATASOURCE=#APPLICATION.DATASOURCE# NAME=GETCLASSES>
8 : SELECT * FROM CLASSES WHERE START_DATE >= #CreateODBCDate(DATEFORMAT(Start_Date, 'mm/dd/yyyy'))# AND START_DATE <= #CreateODBCDate(DATEFORMAT(End_Date, 'mm/dd/yyyy'))#
9 : ORDER BY START_DATE
10 : </CFQUERY>
|