<?xml version="1.0" encoding="gb2312"?>
<%
dim url,db,dbpath,conn,show_username
dim rs,SQL
db="data/oblog221.mdb" ‘這里修改數(shù)據(jù)庫路徑或名稱
Set conn = Server.CreateObject("ADODB.Connection")
dbpath="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.Open dbpath
%>
<rss VERSION="2.0">
<channel>
<TITLE>網(wǎng)站或欄目的名稱</TITLE>
<LINK>網(wǎng)站或欄目的URL地址</LINK>
<description>網(wǎng)站或欄目的簡要介紹</description>
<%
show_username=replace(request.QueryString("name"),"‘","")
‘set rs = Server.CreateObject("ADODB.Recordset")
if show_username<>"" then
SQL="select top 10 * from blog where username=‘"&show_username&"‘ and ishide<>‘true‘ and passcheck<>‘false‘ and isnull(ispassword)=true and (isnull(blog_password)=true or blog_password=‘‘) order by id desc"
else
SQL = "Select top 10 * from blog where ishide<>‘true‘ and passcheck<>‘false‘ and isnull(ispassword)=true and (isnull(blog_password)=true or blog_password=‘‘) order by id desc"
end if
set rs=conn.execute(SQL)
if rs.Eof or rs.Bof then
response.write "<item></item>"
end if
while not rs.Eof
response.Write "<item>"
response.write "<link>"&url&"more.asp?name="&rs("username")&"&id="&rs("id")&"</link>"
Response.write "<title><![CDATA["&rs("topic")&"]]></title>"
response.write "<creator>"&rs("username")&"</creator>"
response.write "<PubDate>"&rs("addtime")&"</PubDate>"
response.write "<description><![CDATA["&rs("logtext")&"]]></description>"
response.write "</item>"
rs.MoveNext
wend
set rs=nothing
conn.Close
set conn = nothing
%></channel></rss>
本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點(diǎn)擊舉報。