◆关于从数据库循环导出HTML的问题
以下是源程序:
<!--#include file="conn.asp" -->
<%
Set modefso = CreateObject("Scripting.FileSystemObject")
set modefile=modefso.getfile(mode.asp)
modets=modefile.openastextstream
do while not modets.atendofstream
content=content+vbcrlf
content=content+changecontent(modets.readline)
loop
%>
<%
set rs=server.createobject("adodb.recordset")
Set fso = CreateObject("Scripting.FileSystemObject")
sqla="select * from product"
rs.open sqla,conn,1,1
do while not rs.eof
newname=rs("name")
newremark=rs("remark")
content=replace("aabbcc",newname)
content=replace("ddeeff",newremark)
NewFile=Server.MapPath("html/"&newname&".html")
Set a = fso.CreateTextFile(NewFile, True)
a.close
File=Server.MapPath("html/"&newname&".html")
Set txt=fso.OpenTextFile(File,8,True)
txt.Write content
txt.Close
%>
<%
rs.movenext
loop
rs.close
set fso=nothing
conn.close
%>
以上代码一执行,提示以下错误:
缺少对象mode
请帮我修正一下代码,万分感谢。。