Every site worth its salt should have RSS feeds for things like news and events.

An RSS looks like this -> http://www.cfmyadmin.com/rss/ and is used by programs called RSS aggrators like this one -> http://www.sharpreader.net/ to bring fresh content to the user's desktop.

Use SimpleRSS2 to generate RSS feeds in seconds!!!

• SimpleRSS2 is simple to use!
• It uses smart memory-based caching to ensure that the server processing load is minimal (important when there will be loads of RSS aggregators checking for updates)

At Digital CRew we are comitted to customer satisfaction: if you purchase SimpleRSS2 and have any questions, queries or suggestions, we will be more than happy to help out or upgrade SimpleRSS2 to meet your requirements.

Please email me if you have any questions whatsoever.

Note: This is the encrypted version, the unencrypted version is available here.

Technical Details

Application: Any
Project:  Any
Filename:  SimpleRSS2.cfm
Programmers: Peter Coppinger <peter@digital-crew.com>
    
Description: Custom Tag that generates a RSS feed from database content.
    The RSS spec that explains some field is available here
    -> http://blogs.law.harvard.edu/tech/rss
    The following table lists the required and optional tag fields:
    

Field	Required?	Description
rssFeedTitle	Yes	The title of the RSS feed.
rssFeedDescription	Yes	The description of the RSS feed.
rssFeedImageURL	No	A optional image to display at the top of the feed.
sitelink	Yes	The main site link.
language	No	The ISO language code to use. Default is "en-us" for Us-English.
TTL	No	Time to live in minutes. Returned to client. Also used for caching. Default is 1440 (1 Day).
useCaching	No	If yes, the output is cached to reduce server processor load. Default is "No". It is highly recommended that you set this to "Yes" when going to production. The caching timeout is specified by the TTL attribute.
datasource	Yes	The datasource to use.
username	Yes	The datasource username.
password	Yes	The datasource password.
dbtype	No	The database type. Options are "MySQL", "MSSQL" or "ORACLE". Default is "MySQL". Use "MSSQL" for Microsoft SQl Server.
table	Yes	The database table to use.
orderby	No	The SQL sort order default is "id DESC".
maxItems	No	Number of items to show, default is 20.
idField	Yes	The field in the table that stores the entryId.
titleField	Yes	The field in the table that stores the title.
datetimeField	Yes	The field in the table that stores the entry date.
descriptionField	Yes	The field in the table that stores the full entry text.
itemLinkBase	No	The base URL to use for item links using the idField. If not passed, no links to items will be supplied. e.g. "http://www.site.com/viewnews.cfm?newsId=". Highly recommended.
whereClause	No	Used to specify the where part of the lookup. e.g. "id > 5"

    
Example Usage:

<cf_SimpleRSS2

datasource = "#APPLICATION.db_datasource#"
username = "#APPLICATION.db_username#"
password = "#APPLICATION.db_password#"

useCaching = "yes"

rssFeedTitle = "it@cork news"
rssFeedDescription = "Enjoy the latest it@cork news direct to your RSS aggregator."
rssFeedImageURL = "#APPLICATION.siteURL#images/rsslogo.jpg"
sitelink = "#APPLICATION.siteURL#"

table = "news"
orderby = "newsId DESC"
maxItems = "20"

IdField = "newsId"
TitleField = "newsTitle"
DatetimeField  = "newsDate"
DescriptionField = "news"
ItemLinkBase = "#APPLICATION.siteURL#index.cfm?page=news&newsId="

>

CHANGE LOG:
27 July 2004 Top  Document created.
28 July 2004 Top  Added caching at Keith Gaughans suggestion