28,391
社区成员
发帖
与我相关
我的任务
分享
sub H2XML (strFile,strContent,oMode)
oMode=CInt(oMode)
Set objStream = Server.CreateObject("ADODB.Stream")
On Error Resume Next
With objStream
.Open
.Charset = "ISO-8859-1"
.Position = objStream.Size
.WriteText = strContent
.SaveToFile server.mappath(strFile),oMode '生成的XML文件名
.Close
End With
Set objStream = Nothing
Select Case Err
Case 424 Response.Write "没有权限或目录错误"
Case Else Response.Write Err.Description
End Select
end sub
dim myrss,rss2
rss2=false
myrss = "<?xml version=""1.0"" encoding=""ISO-8859-1"" ?><newsList><news>"
set rs=server.CreateObject("adodb.recordset")
sql="select * from pf_news order by Id desc"
rs.open sql, conn, 1, 1
if not rs.eof then
rss2=true
do while not rs.eof
myrss = myrss&"<date item_url='"&rs("D_Picture")&"' link='"&Rs("PageUrl")&"' itemtitle='"&FunStrvalue(Rs("Text1"),40)&"'></item>"
<date><![CDATA["&rs("pf_news_date")&"]]></date><title><![CDATA["&rs("pf_news_category_name")&"]]></title><topic><![CDATA["&rs("pf_news_jj")&"]]></topic><description><![CDATA["&rs("pf_news_content")&"]]></description>
rs.movenext
loop
end if
myrss=myrss & "</news></newsList>"
if rss2=true then
H2XML "xmlnews.xml", myrss, 2
end if