<!--#include file="conn.asp"--> 
<% 
strURL = "http://" & request.servervariables("server_name") & _ 
left(request.servervariables("script_name"),len(request.servervariables("SCRIPT_NAME"))-len("/rss.asp")) //中的/rss.asp為你的該文件名 

sql="select top 100 * from [表名] order by id desc" //根據自己實際修改,top 100 為最新100條,自己修改,同時可以增加查詢條件,如where xxx=1.... 
set rs=server.createobject("adodb.recordset") 
rs.open sql,conn,1,1 
response.contenttype="text/xml" 
response.write "<?xml version=""1.0"" encoding=""gb2312"" ?>" & vbcrlf 
response.write "<rss version=""2.0"">" & vbcrlf 
response.write "<channel>" & vbcrlf 
response.write "<title>xxx.com RSS feed</title>" & vbcrlf 
response.write "<link>" & strURL & "</link>" & vbcrlf 
response.write "<language>zh-cn</language>" & vbcrlf 
response.write "<copyright>An RSS feed for xxx.comcopyright>" & vbcrlf 
while not rs.eof 
response.write "<item>" & vbcrlf 
response.write "<title><![CDATA[" & rs("title") & "]]></title>" & vbcrlf 
response.write "<link>"&strURL"/xxxx.asp?Id="&rs("id")"</link>" & vbcrlf 
response.write "<description><![CDATA[" & rs("主題字段") & "<br />" & rs("內容字段") & "<br /><br />]]></description>" & vbcrlf 
response.write "<pubDate>" & return_RFC822_Date(rs("時間字段"),"GMT") & "</pubDate>" & vbcrlf 
response.write "</item>" & vbcrlf 
rs.movenext 
wend 
response.write "</channel>" & vbcrlf 
response.write "</rss>" & vbcrlf 
rs.close 
set rs=nothing 

Function return_RFC822_Date(byVal myDate, byVal TimeZone) 
Dim myDay, myDays, myMonth, myYear 
Dim myHours, myMinutes, mySeconds 

myDate = CDate(myDate) 
myDay = EnWeekDayName(myDate) 
myDays = Right("00" & Day(myDate),2) 
myMonth = EnMonthName(myDate) 
myYear = Year(myDate) 
myHours = Right("00" & Hour(myDate),2) 
myMinutes = Right("00" & Minute(myDate),2) 
mySeconds = Right("00" & Second(myDate),2) 


return_RFC822_Date = myDay", "& _ 
myDays" "& _ 
myMonth" "& _ 
myYear" "& _ 
myHours":"& _ 
myMinutes":"& _ 
mySeconds" "& _ 
" " & TimeZone 
End Function 

Function EnWeekDayName(InputDate) 
Dim Result 
Select Case WeekDay(InputDate,1) 
Case 1:Result="Sun" 
Case 2:Result="Mon" 
Case 3:Result="Tue" 
Case 4:Result="Wed" 
Case 5:Result="Thu" 
Case 6:Result="Fri" 
Case 7:Result="Sat" 
End Select 
EnWeekDayName = Result 
End Function 

Function EnMonthName(InputDate) 
Dim Result 
Select Case Month(InputDate) 
Case 1:Result="Jan" 
Case 2:Result="Feb" 
Case 3:Result="Mar" 
Case 4:Result="Apr" 
Case 5:Result="May" 
Case 6:Result="Jun" 
Case 7:Result="Jul" 
Case 8:Result="Aug" 
Case 9:Result="Sep" 
Case 10:Result="Oct" 
Case 11:Result="Nov" 
Case 12:Result="Dec" 
End Select 
EnMonthName = Result 
End Function 
%> 

<!--#include file="conn.asp"--> 
<% 
strURL = "http://" & request.servervariables("SERVER_NAME") & _ 
left(request.servervariables("SCRIPT_NAME"),len(request.servervariables("SCRIPT_NAME"))-len("/rss.asp")) 
dim foolcat,js 
set js = server.CreateObject("ADODB.RecordSet") 
sql = "select * from [表名] order by id asc" 
set js = conn.execute (sql) 

foolcat = foolcat + "<?xml version=""1.0"" encoding=""UTF-8"" ?>" 
foolcat = foolcat + "<rss version=""2.0"">" 
foolcat = foolcat + "<channel>" 
foolcat = foolcat + "<title>xxx.com XML feed</title>" 
foolcat = foolcat + "<link>" & strURL & "</link>" 
foolcat = foolcat + "<language>zh-cn</language>" 
foolcat = foolcat + "<copyright>An XML feed for xxx.com</copyright>" 
do until js.eof 
foolcat = foolcat + "<item>" 
foolcat = foolcat + "<title><![CDATA[" & rs("主題字段") & "]]></title>" 
foolcat = foolcat + "<description><![CDATA[" & rs("主題字段") & "<br />" & rs("內容字段") & "<br /><br />]]></description>" 
foolcat = foolcat + "<link>" & strURL & "/xxx.asp?Id="&rs("id字段")"</link>" 
foolcat = foolcat + "<pubDate>" & rs("時間字段") & "</pubDate>" 
foolcat = foolcat + "</item>" 
js.movenext 
loop 
js.close 
set js = nothing 
foolcat = foolcat + "</channel>" 
foolcat = foolcat + "</rss>" 
foolcat = "" + foolcat + "" 
foolcat = "" & foolcat & "" 
FolderPath = Server.MapPath("/") 
Set fso = Server.CreateObject("Scripting.FileSystemObject") 
Set fout = fso.CreateTextFile(FolderPath"/rss.xml") 
fout.writeLine foolcat 
fout.close 
set fout = nothing 
conn.close 
set conn = nothing 
%>