homepage Welcome to WebmasterWorld Guest from 54.161.175.231
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / RSS, ATOM, and Related Technologies
Forum Library, Charter, Moderators: bill & werty

RSS, ATOM, and Related Technologies Forum

    
building an RSS feed from Access database?
I'm currently editing the XML manually, but I want to automate
Stratus42




msg:3052584
 9:56 am on Aug 19, 2006 (gmt 0)

Hey folks,

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?

any ideas for me?

cheers!

Stratus

 

weppos




msg:3052642
 12:33 pm on Aug 19, 2006 (gmt 0)

Sure.
Query your access database than dinamically create your feed from database.

To create the feed just "write" the content.

For example

Do While Not objRs.EOF
Response.Write("<item>")
Response.Write("<title>" & objRs("Title") & "</title>")
Response.Write("<link>" & objRs("Link") & "</link>")
Response.Write("<description>" & objRs("Description") & "</description>")
Response.Write("</item>")
objRs.MoveNext
Loop

Stratus42




msg:3053574
 4:21 pm on Aug 20, 2006 (gmt 0)

Hi!

thanks, yes I thought of that.. but that will make my RSS file a .asp file right? and dosn't it need to be a .xml file?

stratus

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / RSS, ATOM, and Related Technologies
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved