Question

怎么在ASP中实现RSS订阅

如题 一个基于WEB新闻发布系统 需要实现自动采集新闻的功能 网上说用RSS订阅功能能轻松实现 求教怎么用
求大神帮忙。。。
小弟QQ 41 624oo 04

Answer 1

RSS一般是输出最新的信息，有自己的xml格式，必须严格遵守
给你一个摘自某asp系统的样例程序，　输出RSS的代码．当然代码不是完整的，只是给个样子．

Sub RSS_View
Dim MyHomeUrl
MyHomeUrl = LD_GetUrl(1)
Dim BoardID
BoardID = Request.QueryString("ID")
If BoardID = "" Then BoardID = Request.QueryString("BoardID")
If BoardID = "" Then BoardID = Request.QueryString("b")
If isNumeric(BoardID) = 0 Then BoardID = 0
BoardID = Fix(cCur(BoardID))
OpenDatabase

Dim Temp
If BoardID > 0 Then
Temp = Application(DEF_MasterCookies & "BoardInfo" & BoardID)
If isArray(Temp) = False Then
ReloadBoardInfo(BoardID)
Temp = Application(DEF_MasterCookies & "BoardInfo" & BoardID)
End If
If isArray(Temp) = False Then BoardID = 0
End If
Dim SQLEndString
Dim Rs,GetData,RssNum
IF BoardID > 0 Then
select case DEF_UsedDataBase
case 0,2:
SQLEndString = "and TA.BoardID=" & BoardID & " Order by TA.RootIDBak DESC"
case Else
SQLEndString = "where TA.BoardID=" & BoardID & " Order by TA.ID DESC"
End select
Else
SQLEndString = " Order by TA.ID DESC"
End If
select case DEF_UsedDataBase
case 0,2:
Set Rs = LDExeCute(sql_select("select TA.ID,TA.BoardID,TA.Title,TA.Content,TA.ndatetime,TA.LastTime,TA.UserName,TA.LastUser,TA.TitleStyle,TB.BoardName,TA.HTMLFlag,TB.BoardLimit,TB.ForumPass,TB.OtherLimit,TB.HiddenFlag,TU.TrueName,TU.ID from LeadBBS_Announce as TA left join LeadBBS_Boards as TB on TA.BoardID=TB.BoardID left join LeadBBS_User as TU on TU.Id=TA.Userid where TA.ParentID = 0 " & SQLEndString,RSS_ViewNumer),0)
case Else
Set Rs = LDExeCute(sql_select("select TA.ID,TA.BoardID,TA.Title,'',TA.ndatetime,TA.LastTime,TA.UserName,TA.LastUser,TA.TitleStyle,TB.BoardName,0,TB.BoardLimit,TB.ForumPass,TB.OtherLimit,TB.HiddenFlag,TU.TrueName,TU.ID from (LeadBBS_Topic as TA left join LeadBBS_Boards as TB on TA.BoardID=TB.BoardID) left join LeadBBS_User as TU on TU.Id=TA.Userid " & SQLEndString,RSS_ViewNumer),0)
End select
If Not rs.Eof Then
GetData = Rs.GetRows(-1)
RssNum = Ubound(GetData,2)
Else
RssNum = -1
End If
Rs.close
Set Rs = Nothing
CloseDatabase

Dim PostTime
Response.ContentType="application/xml"
Response.Write "<?xml version=""1.0"" encoding=""gb2312""?>"
'<?xml-stylesheet type="text/css" href="rss.css"?>
'<?xml-stylesheet type="text/xsl" href="viewforfeed.xslt"?>
%>
<rss version="2.0">
<channel>
<%
IF BoardID = 0 or RssNum = -1 Then
Temp = ""
Else
Temp = " " & HtmlEncode(KillHTMLLabel(GetData(9,0)))
End If
Response.Write "<title><![CDATA[ " & HtmlEncode(DEF_SiteNameString & " " & DEF_BBS_Name) & Temp & " ]]></title>" & VbCrLf
%>
<link><%=MyHomeUrl%></link>
<description><![CDATA[ <%
If Temp = "" Then
Response.Write "所有版面"
Else
Response.Write "版面：" & Temp
End IF%> 最新<%=RSS_ViewNumer%>条主题 ]]></description>
<language>zh-cn</language>
<copyright>Copyright(C)LeadBBS.COM</copyright>
<webMaster>Info@LeadBBS.COM</webMaster>
<generator>LeadBBS.COM</generator>
<lastBuildDate><%=RestoreTime(GetTimeValue(DEF_Now))%></lastBuildDate>
<ttl>30</ttl>
<image>
<url><%=MyHomeUrl%>images/logo.gif</url>
<title><![CDATA[ <%=HtmlEncode(DEF_SiteNameString)%> ]]></title>
<link><%=MyHomeUrl%></link>
</image>
<%
IF RssNum = -1 Then
Response.Write "<item></item>"
Else
Dim N
For n = 0 to RssNum
If GBL_CheckLimitTitle(GetData(12,N),GetData(11,N),GetData(13,N),GetData(14,N)) = 1 Then
GetData(2,N) = "查看此帖子标题需要特殊权限."
GetData(7,N) = "隐藏"
GetData(6,N) = "隐藏"
GetData(10,N) = 1
End If
If GBL_CheckLimitContent(GetData(12,N),GetData(11,N),GetData(13,N),GetData(14,N)) = 1 Then GetData(3,N) = "查看此帖子内容需要特殊权限"
If GetData(8,N) = 1 Then GetData(2,N) = KillHTMLLabel(HtmlEncode(GetData(2,N)))
if GetData(7,N) <> "" then GetData(7,N) = "最后回复：" & HtmlEncode(GetData(7,N)) & " at " & RestoreTime(GetData(5,N)) & VbCrLf
Response.Write "<item>" & VbCrLf
Response.Write "<title><![CDATA[ " & HtmlEncode(GetData(2,N)) & " ]]></title>" & VbCrLf
Response.Write "<link>" & MyHomeUrl & "a/" & replace(RW_a(GetData(1,N),GetData(0,N),1,1,""),"&","&") & "</link>" & VbCrLf
Response.Write "<author><![CDATA[ " & HtmlEncode(GetData(6,N)) & " ]]></author>" & VbCrLf
Response.Write "<category><![CDATA[ " & HtmlEncode(KillHTMLLabel(GetData(9,N))) & " ]]></category>" & VbCrLf
Response.Write "<pubDate>" & RestoreTime(GetData(4,N)) & "</pubDate>" & VbCrLf
Response.Write "<description><![CDATA[ " & GetData(7,N)
Response.Write "<br>所在版面：<a href=" & MyHomeUrl
response.write "b/" & RW_b(GetData(1,N),0,"")
response.write ">" & HtmlEncode(KillHTMLLabel(GetData(9,N))) & "</a>" & VbCrLf
If ccur(GetData(16,N)&"")>0 then
Response.Write "<br>帖子作者：<a href=" & MyHomeUrl & "User/" & RW_User(GetData(16,N),"","","") & ">" & HtmlEncode(GetTrueName(GetData(6,N),GetData(15,N))) & "</a>" & VbCrLf
else
Response.Write "<br>帖子作者：" & HtmlEncode(GetTrueName(GetData(6,N),GetData(15,N))) & VbCrLf
end if
Response.Write "<br>内容提要："
If isNull(GetData(3,N)) Then GetData(3,N) = ""
GetData(3,N) = Left(GetData(3,N),200)
Select Case GetData(10,N)
Case 1
Response.Write Server.HtmlEncode(KillHTMLLabel(GetData(3,N)))
Case 2
Response.Write Server.HtmlEncode(clearUbbcode(GetData(3,N)))
Case Else
Response.Write Server.HtmlEncode(GetData(3,N))
End Select
Response.Write " ]]></description>" & VbCrLf
Response.Write "</item>"
Next
End IF
%>
<LeadBBS>
<ExeCuteTime>耗时<%=FormatNumber(cCur(Timer - DEF_PageExeTime1),3,True)%>秒</ExeCuteTime>
<Query>请求<%=GBL_DBNum%>次</Query>
</LeadBBS>
</channel>
</rss>
<%
End Sub