On 10/11/06, Tom King <[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
Teddy's advice makes sense, but I'll add one thing I learned (or learned to prefer, perhaps) that may or may not be covered in the CFDJ article: don't remove invalid characters. Instead, wrap content which may contain invalid characters in CDATA blocks. <![CDATA[Your potentially invalid content]]> The benefit is that your content is maintained exactly as it was entered without affecting the XML validity. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:256280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
