Generate RSS Feed using ColdFusion
<cfset START_DATE = CreateODBCDate('2015,1,1')>
<cfset END_DATE = CreateODBCDate('2015,12,31')>
<cfset EMPLOYEE_ID = '#session.unit_id#'>
<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 = '#EMPLOYEE_ID#'
order by END_DTTM ASC
</cfquery>
<!--- begin RSS Tutorial --->
<cfscript>
myStruct = StructNew();
myStruct.link = "http://medsched.medinfo.rochester.edu/medsched/";
myStruct.title = "MSS Employee RSS Feed";
myStruct.pubDate = Now();
myStruct.description = "MSS Employee Times";
myStruct.version = "rss_2.0";
//map the orders column names to the feed query column names.
columnMapStruct = StructNew();
columnMapStruct.publisheddate = "MODIFY_DT";
columnMapStruct.content = "TIME_CODE";
columnMapStruct.title = "END_DTTM";
columnMapStruct.rsslink = "EMPLOYEE_ID";
</cfscript>
<cffeed action="create"
query="#getUnitTimes#"
properties="#myStruct#"
columnMap="#ColumnMapStruct#"
outputFile="#EMPLOYEE_ID#-Feed.xml"
overwrite="yes"
xmlVar="myXML">
<cflocation url="#EMPLOYEE_ID#-Feed.xml" />