- Investigate possibility of exporting website data as an XML/RSS feed to other (selected) websites
Not too sure of the finer details. We are on CF5 and use Paperthin's CF based content management system where all data is stored in Commonspot's defined DB tables.
Does commonspot have some API for obtaining content from it's DB tables or is it necessary to actually write/copy SQL yourself?
I have absolutely no exposure to XML or RSS and need some advice if this sort of thing is possible and where to start looking? Have read a couple of intros to XML/RSS to get a bit of backgound but as I say, I am completely new.
As you really only need to produce well-formed XML, you do not need to use an XML API such as the W3C DOM to produce your XML feed (so you don't need to use the MSXMLDOM or SOXML or any of that jazz). You can produce a well-formed XML document using ColdFusion just as you would a HTML document.
RSS is a bit of a nightmare, because the various standards are somewhat incompatible (see http://diveintomark.org/archives/2004/02/04/incompatible-rss ).
If you like, I can mail you a custom tag I use to produce RSS 1.0 feeds from our content management system (speckcms). You should be able to rip off the code to produce something similar for CommonSpot, you'll just have to replace the code which obtains the content from CommonSpot. Some examples of this tag in use are at http://www.dublinks.com/feeds/rdf.cfm and http://www.fashion.ie/feed/rdf.cfm
Hope this helps
Mark
Would greatly appreciate any advice you can give me.
_______________________________________________________<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
* Regards, Richard Lovelock, Senior Application Analyst.
Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG
( 0870 906 7482
_______________________________________________________
=======================================================
This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
=======================================================
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
