OK, starting with January through September - this works great. It pulls
up the current month and the next three months worth of events.
<cfset startDATE = #now()#>
<cfset threemonths = DateAdd("m",3,startDATE)>
<cfquery name="calendar">
SELECT
id, event_date, event_name FROM events
WHERE month(event_date) >= #month(startDATE)#
and event_date < #threemonths#
and year(event_date) >= #year(startDATE)#
ORDER BY event_date,event_time ASC
</cfquery>
But - it won't jump across the year change. So, starting in November
2006, for example, it only shows November and December, even though
there are events in Jan. and Feb. 2007.
Fix is probably easy, but I ain't seeing it right now...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240872
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
