2006-5-22 Asp Access 创建静态文件/HTML By Stabx

王朝asp·作者佚名  2006-05-23
窄屏简体版  字體: |||超大  

标题: 2006-5-22 Asp Access 创建静态文件/HTML By Stabx

正文:

QUOTE:

作用说明:

本代码实现从 Access 提取数据以创建 HTML 文件, 不建文件夹.

如果文件名与要创建的文件名相同, 则覆盖, 跟 SQL 的更新一样的原理.

待加功能: 删除与查找.

shawl.qiu

2006-5-22

CODE:

<%

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

'

' subject : Asp 创建静态文件/HTML By Stabx

'

' writer : Stabx<shawl.qiu@gmail.com>

'

' blog : http://btbtd.exblog.jp/ ;

'

' blog/site : Phoenix.GI - P.GI / \ 绿色学院 - Green Institute

'

' date : 2006-5-22

'

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Set rs = Server.CreateObject("ADODB.Recordset")

sql = "select top 10 * from (select top 3500 * from ctarticle order by articleid asc) order by articleid desc" '子查询, 目前被认为比恐龙还恐龙

rs.Open sql, MM_conn_string,1

while not rs.eof '循环创建查询的全部记录为 HTML 文件

cid_=rs("classid")

ncid_=rs("nclassid")

aid_=rs("articleid")

adt_=rs("dateandtime")

tt_=rs("title")

ct_=rs("content")

'em_=htmlToText(rs("email"))

'ht_=rs("hits")

'url_=rs("url")

'src_=rs("www")

'au_=htmlToText(rs("writer"))

response.write "<a href=""" & cid_ & "_"&ncid_&"_"&aid_&".htm"" target=""_blank"">"&cid_ & "_"&ncid_&"_"&aid_& ".htm</a> created at " & now() & "<br>" '链接创建好的文件

cfilename= cid_& "_"&ncid_&"_"&aid_& ".htm" '命名要创建的文件名

set dfso = createobject("scripting.filesystemobject")

Set chtml = dfso.CreateTextFile(server.mappath(cfilename), true)'存在即覆盖

chtml.WriteLine("<html><head>")

chtml.WriteLine("<link rel='stylesheet' type='text/css' href='../css/css_first/ctarticle.css'>")

chtml.WriteLine("<title>"&sitename_&" "&tt_&"</title>")

chtml.WriteLine("</head><body>")

chtml.WriteLine("title: " & tt_& "<p/>" )

chtml.WriteLine("content: " & ct_& "<p/>" )

chtml.WriteLine("created by cid:"&cid_&" ncid:"&ncid_&" aid:"&aid_&"

")

aid_=clng(aid_)

chtml.WriteLine("Page created on: " & now ())

chtml.WriteLine("</body></html>")

chtml.close

rs.movenext

wend

rs.close

set rs=nothing %>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有  導航