不错呦!smile@林凯西,确保“准备文件”中的几个文件都有安装,S...您好,看了您这篇帖子觉得很有帮助。但是有个问题想请...我的修改过了怎么还被恶意注册呢 @jjjjiiii 用PJ快9年了,主要是A...PJ3啊,貌似很少有人用PJ了,现在不是WP就是z...@332347365,我当时接入时错误码没有-10...楼主,ChkValue值应为-103是什么意思呢?...大哥 你最近能看到我发的信息,请跟我联系,我有个制...
动网风格分析助手
编辑:dnawo 日期:2007-06-08
一、rstotxt.asp:
以各字段名做文件名,并将其内容分别保存于txt文件中,当然,也可保存成htm文件。
二、rstofolder.asp:
以各字段名为文件夹名,并将字段内容以"|||"为分割点分别保存于txt文件中,也可保存为htm文件。
复制内容到剪贴板 程序代码
<%
Dim objConn,objRs,objFSO,objTS
Dim i
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.RecordSet")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objConn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("Dvbbs7.mdb")
objConn.open
objRs.open "select * from Dv_Style where id=1",objConn,1,3
If not objRs.eof Then
For i = 0 to objRs.fields.count-1
'If objRs(i).name="Main_Style" Then '导出指定字段
Set objTS = objFSO.CreateTextFile(Server.MapPath(objRs(i).name & ".txt"))
objTS.write objRs(i).value
objTS.close
Set objTS = nothing
'End if
Next
End if
Set objFSO = nothing
objRs.close
Set objRs =nothing
objConn.close
Set objConn = nothing
%>
Dim objConn,objRs,objFSO,objTS
Dim i
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.RecordSet")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objConn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("Dvbbs7.mdb")
objConn.open
objRs.open "select * from Dv_Style where id=1",objConn,1,3
If not objRs.eof Then
For i = 0 to objRs.fields.count-1
'If objRs(i).name="Main_Style" Then '导出指定字段
Set objTS = objFSO.CreateTextFile(Server.MapPath(objRs(i).name & ".txt"))
objTS.write objRs(i).value
objTS.close
Set objTS = nothing
'End if
Next
End if
Set objFSO = nothing
objRs.close
Set objRs =nothing
objConn.close
Set objConn = nothing
%>
以各字段名做文件名,并将其内容分别保存于txt文件中,当然,也可保存成htm文件。
二、rstofolder.asp:
复制内容到剪贴板 程序代码
<%
Dim objConn,objRs,objFSO,objTS
Dim i,j,strTemp,arrTemp
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.RecordSet")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objConn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("Dvbbs7.mdb")
objConn.open
objRs.open "select * from Dv_Style where id=1",objConn,1,3
If not objRs.eof Then
For i = 0 to objRs.fields.count-1
'If objRs(i).name="page_index" Then '导出指定字段
strTemp = Server.MapPath(".") & "\" & objRs(i).name
objFSO.CreateFolder(strTemp)
arrTemp = split(objRs(i).value,"|||")
For j=LBound(arrTemp) to UBound(arrTemp)
Set objTS = objFSO.CreateTextFile(strTemp & "\" & j & ".txt")
objTS.write arrTemp(j)
objTS.close
Set objTS = nothing
Next
'End if
Next
End if
Set objFSO = nothing
objRs.close
Set objRs =nothing
objConn.close
Set objConn = nothing
%>
Dim objConn,objRs,objFSO,objTS
Dim i,j,strTemp,arrTemp
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRs = Server.CreateObject("ADODB.RecordSet")
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
objConn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath("Dvbbs7.mdb")
objConn.open
objRs.open "select * from Dv_Style where id=1",objConn,1,3
If not objRs.eof Then
For i = 0 to objRs.fields.count-1
'If objRs(i).name="page_index" Then '导出指定字段
strTemp = Server.MapPath(".") & "\" & objRs(i).name
objFSO.CreateFolder(strTemp)
arrTemp = split(objRs(i).value,"|||")
For j=LBound(arrTemp) to UBound(arrTemp)
Set objTS = objFSO.CreateTextFile(strTemp & "\" & j & ".txt")
objTS.write arrTemp(j)
objTS.close
Set objTS = nothing
Next
'End if
Next
End if
Set objFSO = nothing
objRs.close
Set objRs =nothing
objConn.close
Set objConn = nothing
%>
以各字段名为文件夹名,并将字段内容以"|||"为分割点分别保存于txt文件中,也可保存为htm文件。
评论: 1 | 引用: 0 | 查看次数: 4123
发表评论
请登录后再发表评论!