[midasxl]

Thanks in advance for your time and assistance! I am building an RSS feed from a database query as show in the code below. As you can see in the loop that builds the rss nodes I am trying to include the date, but it does not show up in the resulting feed. Anyone see what I may be doing wrong? Is <date> a legitimate node? Thanks again!

<!---Query the database--->
<cfquery name="feed" datasource="my_source">
SELECT *
FROM rss_current_news
WHERE active_flag = 1
ORDER BY mod_datetime DESC
</cfquery>

<!---***********************************begin .xml generation**********************************************--->

<!---Remove white space from generated content in the tag body--->
<cfprocessingdirective suppresswhitespace="yes"><!---Prevents ColdFusion from putting white space characters in front of the XML declaration--->
<!---Create a CF XML document object that contains the markup--->
<cfxml variable="xmlobject" casesensitive="yes">

<rss version="2.0">
<channel>
<title>NCDOC RSS Feed</title>
<link>rss/feed/</link>
<description>RSS Feed for Current NCDOC News </description>
<lastbuilddate>Date and Time of Last Change</lastbuilddate>
<language>en-us</language>
	<cfoutput>
			   
	  <cfloop query="feed">
	  
			  <item>
				<title>#XmlFormat(feed.title)#</title>
				<description>#XmlFormat(feed.caption)#</description>
				<date>#XmlFormat(feed.mod_datetime)#</date>
				<link>#XmlFormat(feed.link)#</link>
			</item>
	  
	   </cfloop>
	   
	 </cfoutput>
</channel>
</rss>

</cfxml>
</cfprocessingdirective>

<cfoutput>#xmlobject#</cfoutput>

<!---***********************************end .xml generation**********************************************--->

[midasxl]

OK, I figured out I need to use <pubDate> instead of just <date>. But now I have another question. My most recent feed item reads "Today, July 27, 2009, 6 Hours Ago". Why does it say 6 hours ago? I just put it up?? Thanks!

[xheartonfire43x]

Can you post the RSS code that your web browser receives?

This post has been edited by xheartonfire43x: 28 July 2009 - 12:10 PM

[midasxl]

xheartonfire43x,
Here is the code from the browser. I have one item in the feed for simplicity. I added the item at 08:13 today, and the feed reads "added 4 hours ago." Thanks for your assistance.

<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>RSS Feed</title>
<link>rss/feed/</link>
<description>RSS Feed for Current News </description>
<lastbuilddate>Date and Time of Last Change</lastbuilddate>
<language>en-us</language>
	
	  
<item>
				<title>Test</title>
				<description>Test</description>
				<pubDate>2009-08-03 08:13:04.0</pubDate>
				<link/>
</item> 
	   
	  
				 
	   
</channel>
</rss> 

[xheartonfire43x]

midasxl, on 3 Aug, 2009 - 04:17 AM, said:

xheartonfire43x,
Here is the code from the browser. I have one item in the feed for simplicity. I added the item at 08:13 today, and the feed reads "added 4 hours ago." Thanks for your assistance.

<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title>RSS Feed</title>
<link>rss/feed/</link>
<description>RSS Feed for Current News </description>
<lastbuilddate>Date and Time of Last Change</lastbuilddate>
<language>en-us</language>
	
	  
<item>
				<title>Test</title>
				<description>Test</description>
				<pubDate>2009-08-03 08:13:04.0</pubDate>
				<link/>
</item> 
	   
	  
				 
	   
</channel>
</rss> 

Could it be that your local machine & your coldfusion server are on different timezone settings?

[midasxl]

Ok, better late than never. I have revisited this one and have come up with the following...

<cfset todayDate=#feed.add_date#>
<cfset thisDate="#DateFormat(todayDate, 'ddd, dd mmm yyyy')# #TimeFormat(todayDate, 'hh:mm:ss')# EDT">
<item>
<title>#XmlFormat(feed.title)#</title>
<description>#XmlFormat(feed.caption)#</description>
<pubDate>#thisDate#</pubDate>
<link>#XmlFormat(feed.URL)#</link>
</item>

I specified the time and date format. Apparently if you do not specify the time zone (in this case EDT) it defaults to GMT.

[CR250]

Just in case you didn't know and for anyone that stumbles on this thread you can create RSS feeds with CF8 here is an excellent example:

http://tutorial27.learncf.com/