Generate JSON of employee schedule data
<cfset START_DATE = CreateODBCDate('2015,1,1')>
<cfset END_DATE = CreateODBCDate('2015,12,31')>
<cfquery name="getUnitTimes"
datasource="#application.datasrc_mss#"
dbtype="#application.dbtype_mss#">
SELECT UNIT_ID,
END_DTTM,
EMPLOYEE_ID,
TIME_CODE,
NP_TIME_CODE,
MODIFY_DT
FROM employee_times
WHERE END_DTTM >= #START_DATE#
AND END_DTTM <= #END_DATE#
AND EMPLOYEE_ID = '228646'
order by END_DTTM ASC
</cfquery>
<!--- Generate a clean feed by suppressing white space and debugging info. --->
<cfprocessingdirective suppresswhitespace="yes">
<cfcontent type="application/x-json">
<cfscript>
myJSON = SerializeJSON(getUnitTimes, true, false);
writeOutput("onLoad("&myJSON&")");
</cfscript>
</cfprocessingdirective>