Here's a question for the crowd, I have an rss feed on my site that has on it all the forthcoming events from our calendar of events.
Right now, I edit the xml manually - adding a new one of these:
<item> <title>5 October 2010 - to - 8 October 2010</title> <link>http://www.fakesite.org/calendar/event_display.asp?date=10-05-2006#87</link> <description>Description of fake event</description> </item>
for each new forthcoming event in our calendar.
But, this calendar is in ASP, and all the events and dates and such are in an access database..
soooo... is there any way for me to automate the process of building this feed? how do I go about makeing an XML file using the data from my Access database and standard ASP?