b1nary0mega
5/13/2016 - 1:23 PM

Generate RSS Feed using ColdFusion

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" />