posted on Thursday, January 22, 2004 11:37 AM
by
demiliani
RSS Feed creation via classic ASP pages
Yesterday i was trying to create a RSS feed for my ASP pages and my idea was to use a script like this:
<%
Response.ContentType = "text/xml"
%>
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd"> <rss version="0.91">
<channel>
<title>RSS Feed creation</title>
<link>http://www.demiliani.it/</link>
<description>Trying to create a RSS Feed via ASP...</description>
<language>it</language>
<%
' Here I estract the Data from my Database
Set
objConn = Server.CreateObject ("ADODB.Connection") objConn.Open strConn
set
rs = objConn.execute("SELECT TOP 10 * FROM MyTable ORDER BY Data DESC") Do
while rs.eof response.write " <item>" &VbCrLf
response.write " <title>"& rs("Title") &"</title>" &VbCrLf
response.write " <link>" & rs("URL") &"</link>" &VbCrLf
response.write " <description>"& rs("Description") &"</description>" &VbCrLf
response.write " </item>" &VbCrLf
rs.movenext
loop
rs.close
set
rs = nothing objConn.close
set
objConn = nothing %>
</channel>
</rss>
It seems to work quite good... I've obtained a simple RSS Feed. Do you know other scripts to create RSS Feeds via classic ASP that works better? If yes, I'm really interested :)