I was just tinkering with doing it manually a while back, to see how it worked, and then a clever guy came along and worked out how to automate it with PHP and MySQL. Here is the link to his solution:
See if that helps. Is you CMS a brand name one, or is it custom built? If it's a brand name one,I'm sure there are native solutions for RSS.