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

Coldfusion Facebook Graph API publish to your wall and your friends walls

In this tutorial we will learn by full coldfusion Graph API code example how to publish on your wall and your friends walls. This application uses new oauth authentication method.

The code is divided into four files: we will first start with a file called index.cfm:

<cfoutput>    
    <!--- Your FB application IDS --->
      <cfset api_key = ""/>
    <cfset secret_key = ""/>
    <cfset appID = ""/>
<!--- create a connection to the fb graph cfc --->
    <cfset graphCFC = createObject("component", "graph").init(#appID#, #api_key#, #secret_key#) />
    <!--- If user is authenticated or his access token is set create a cookie --->     <cfif not isdefined("cookie.access_token") and isdefined("url.access_token")>
        <cfset cookie.access_token=url.access_token>
    </cfif> <!--- If the user is authenticated and access token is set, then make the action…

Error: Write to Disk Access Denied - Troubleshooting - BitTorrent

I have downloaded Bit Torrent software and when trying to download I got an error after few seconds saying:

Error: Write to Disk Access Denied
Solving this problem is so simple:
Shut down BitTorrent program.
Go to Start and in the small search box on top of windows start button start typing Bittorrent and the program will show, right click with the mouse on the icon and Run as Administrator.
All ur problems are sorted out now and you can enjoy downloading...
Good Luck.

Implementation of Facebook Graph API in Coldfusion

Facebook has launched a new FB API called Graph that simplifies FB applications development, the new Graph API allows website owners to create Single Sign On (SSO) with Facebook and allow websites owners to be able to import a lot of users information but after their permissions.


The code below written in Coldfusion gives an example on how to Create FB login/logout button and then how to retrieve the created cookie, and use it for further development:

  <body>
  <cfoutput>
<!--- Your FB application IDS --->
    <cfset api_key = "XXXXXXXXXXXXX"/>
    <cfset secret_key = "XXXXXXXXXXXXXX"/>
    <cfset appID = "XXXXXXXXXXXXXX"/>
<!--- Facebook login/logout button --->
    <p><fb:login-button perms="email,user_birthday" autologoutlink="true"></fb:login-button></p>
    <!--- Facebook login/logout button that publishes to your wall--->
    <p><fb:like></fb:like…