<cfquery name="Q_Month" datasource="command_calendar">
SELECT
Title,
Details,
EventDate,
StartHour,
StartMin
FROM
Events
WHERE
EXTRACT (YEAR FROM EventDate) = <cfqueryparam
cfsqltype="cf_sql_integer" value="#Year(Now())#">
AND
EXTRACT (MONTH FROM EventDate) = <cfqueryparam
cfsqltype="cf_sql_integer" value="#Month(Now())#">
ORDER BY
EventDate ASC
</cfquery>
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
