Thanks to all for the tips! Ray - i've got your rss.cfc working a treat:
However, much as I am a newbie, I have to point out that on line 177 of the cfc, for valid XML should read: <dc:date>#dateFormat(arguments.data.date,"yyyy-mm-dd")#T#timeFormat (arguments.data.date,"HH:mm:ss")##numberFormat(z.utcHourOffset,"00")#: 00</dc:date> (as the cfif statement there is seemingly redundant, as the - or + is in the HourOffset already) Probably a CF 7 thing? T On 11 Oct 2006, at 15:03, Raymond Camden wrote: > A bit old - but it worked just fine last time I tested it: > > http://ray.camdenfamily.com/index.cfm/2005/5/10/RSScfc-Update > > On 10/11/06, Larry Lyons <[EMAIL PROTECTED]> wrote: >>> Hi all, >>> >>> I'm looking for some code to create RSS feeds from a DB output (i.e >>> news , you know the sort of thing) >>> Ideally I'm looking for something which will let me specify a query >>> and then output the contents into a flat XML file, preferably >>> removing all the potentially invalid chars.. >>> >>> Any CFCs out there? >>> >>> Thanks, >>> T >> >> Here are a few tutorials on the topic: >> http://www.petefreitag.com/item/465.cfm >> http://blog.daemon.com.au/archives/000104.html >> http://www.devx.com/xml/Article/10790/0/page/1 >> >> As for existing CFC's, its relatively simple so I've just rolled >> out my own. >> >> hth, >> larry >> >> -- >> Larry C. Lyons >> Web Analyst >> BEI Resources >> American Type Culture Collection >> http://www.beiresources.org >> email: llyons(at)atcc(dot)org >> tel: 703.365.2700.2678 >> -- >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
