<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
ColdFusion Calendar Event Scripting (Inspired By Peter Bell)
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:877.view
Date Posted:
Jul 30, 2007 at 2:14 PM
---- --------------------------------------------------------------------------------------- --->
SELECT
e.id,
e.name,
e.date_started,
e.date_ended,
e.time_started,
e.time_ended,
e.repeat_type
FROM
event e
WHERE
(
e.date_ended >=
OR
e.date_ended IS NULL
)
AND
e.date_started <=
SELECT
*,
( 0 ) AS day_index
FROM
qRawEvent
WHERE
repeat_type = 0
(dtFirstDay LTE dtDay) AND
(dtDay LTE dtTo) AND
(
(NOT Len( lstDaysOfWeek )) OR
ListFind(
lstDaysOfWeek,
DayOfWeek( dtDay )
)
))>