Skip to main content

How to Build RSS 2.0 Feed in Coldfusion 8

In this tutorial I will show some tips on how to create an RSS Feed in coldfusion by querying a Database.

This example will demonstrate how to create an RSS Feed for the quote of the day.

< cfquery name="qname" datasource="dbsource" maxrows="3">
SELECT PUBDATE,DESCR,FTITLE,LINK FROM wiki.url.rssfeed order by id desc
</cfquery>

<!--- Note here the query returns only the last three quotes and also it is sorted based on the id which is an auto increment ID.--->
<cfscript>
myStruct = StructNew();
mystruct.link = "http://blog.abusalah.info";
myStruct.title = "Mustafa Abusalah Quote of the Day";
mystruct.description = "Quote of the Day Tutorial";
mystruct.pubDate = Now();
mystruct.version = "rss_2.0";

<!--- Now the Query columns must be mapped to the RSS columns this is done by creating a struct and mapping them to the struct variables. Please not that the fields must be written in capital letters don't ask me why.--->
columnMapStruct = StructNew();
columnMapStruct.publisheddate = "PUBDATE";
columnMapStruct.content = "DESCR";
columnMapStruct.title = "FTITLE";
columnMapStruct.rsslink = "LINK";
</cfscript>

<!--- The last step is to Generate the xml file using the CFFEED--->
<cffeed action = "create"
query= "#qname#"
properties="#mystruct#"
columnMap="#columnMapStruct#"
outputFile = "quoteFeed.xml"
overwrite = "yes"
xmlVar = "myXML">

Now to see the RSS Feed result in your browser simply browse quoteFee.xml or call the following function from your CFML code:

<cffeed source = "quoteFee.xml"
properties = "myProps"
query = "myQuery">


Then print the output of the query.

Comments

Popular posts from this blog

Top Google Adsense Alternatives

Google Adsense is a web tool that allows publishers in the Google Network of content sites to automatically serve text, image, video, and rich media adverts that are targeted to site content and audience. These adverts are administered, sorted, and maintained by Google, and they can generate revenue on either a per-click or per-impression basis.  Google servers advertisers using google adwords platform, while adsense is the publishers platform. Google Adsense is the top Ad Publishers platform over the web ranking number one in web advertising industry. Adsense offers contextual advertisements that covers web sites, blogs, games, videos, mobile browsing etc. What made Google Adsense no. 1 is the reliability, stability, variety of services and large number of publishers including google it self. Also google has a fair platform that detects invalid clicks so google successfully protects its advertisers and also offers its best publishers top CPC. Two reasons are behind people think

The Semantic Web

Semantic Web aims to create a meaning and define inter-relationship for information available on the web In the early stages of the World Wide Web (web) it was necessary to develop standards to view web content (HTML language) and to create communication channels (N-Tier applications, email, ftp, etc.). As the web started to be the world’s largest knowledge base, accessible world wide, it became important to develop tools to transfer knowledge between cultures. However, it is still not possible for applications and agents to interoperate with other applications and agents without having a predefined, human created common framework of the meaning of the information being transferred on both sides. Semantic Web (SW) alleviates this problem by providing a common framework that allows data to be shared and reused across application, enterprise, and community boundaries [W3C Semantic Web, 2019]. A clear example on SW application is schema.org. Google, Bing, Yahoo use schema

Arabs In London

I was not able to watch Arabs in London episodes during the last holy month of Ramadan. I watched it recently on MBC. I was really impressed by the performance of some actors and actresses. The most impressive one was Mais Hamdan who was able to present the Palestinian accent efficiently. This TV series was written and directed by Anwar Qawadri a Syrian director who studied and lived in London. The below video is about 8 minutes show when Sami finds out that his friend Eddy (Adnan) passed away.