How to code dynamic feed with ASP

How do I create a feed with my newest 10 posts

[aish1108]

I have searched high and low and there seems to be nothing out there.

I have a website built with ASP and SQL Server. I want to create a feed which will display my newest 10 articles, posts, etc..

How do I do it?

Also should a feed have an .xml extension?

I found an article somewhere and used it to create this < feed I named rss.asp >
But, it doesn't work at least not in Internet Explorer.

Thanks.

[edited by: tedster at 7:39 pm (utc) on Jan. 2, 2008]
[edit reason] no links, please [/edit]

[bill]

By definition RSS and Atom feeds are in the XML language. The standard way to serve these files is with an .xml extension. However, it's certainly possible to get your server to serve up feeds using any extension you want.

With IIS you'll want to set the MIME-TYPE [webmasterworld.com] in the header.

[aish1108]

Thank You for your attempt to help.

However once again I am still at a lost as to how to create a rss feed using ASP classic?

A dynamic rss feed.

What am I missing. I don't know anything about xml, but why is is so hard to find code which I can reuse?

There seem to be no resources on the internet. I have searched. Nothing.

[bill]

There seem to be no resources on the internet. I have searched. Nothing.

I find that hard to believe. There are plenty of howto articles on the web that explain the process of making an RSS feed. What have you tried? What isn't working for you?

[aish1108]

OK I have an ASP page that will display the newest 10 posts.
It's a simple SQl select from my database.

Now I want this to be a feed .

So visitors can subscribe to it and it should always have the newest 10 posts.
Or the most popular 10 posts or whatever.

How do I turn this into a feed with an .xml extension which will be picked up by IE and feed readers?

I don't want to have to go every day and run the code and then create a feed from it. It needs to be dynamic just like the feeds all over the wonderful internet. But how do I do it.?

Thank You for your help and interest.

[bill]

Sounds like you need to reference some of the ASP sites like asp101, 4guysfromrolla.com and 15seconds.com, or our own forum Microsoft IIS Web Server and ASP.NET [webmasterworld.com].

Here's an article that might get you started: Personalizing RSS Feeds with ASP.NET 2.0 [aspnet.4guysfromrolla.com]