28,390
社区成员
发帖
与我相关
我的任务
分享
if strConnectXLS4 <> "" then
Set FSO = Server.CreateObject("Scripting.FileSystemObject")
If FSO.FileExists(Server.MapPath("Database/newproducts/alt.csv")) Then
Set TSO = FSO.OpenTextFile(Server.MapPath("Database/newproducts/alt.csv"), ForWriting)
Else
Set TSO = FSO.CreateTextFile(Server.MapPath("Database/newproducts/alt.csv"))
End If
objRSXLS4.MoveFirst
count = 0
While Not objRSXLS4.EOF
if aobjRSXLS4(count) <> 1 then
For Each objField in objRSXLS4.Fields
TSO.Write ( objField.Value & "," )/*提示这句出错*/
Next
TSO.Write (vbcrlf)
end if
count = count + 1
objRSXLS4.MoveNext
Wend
objRSXLS4.close
end if
<%
Option Explicit
Server.ScriptTimeout = 900000
Dim count
Dim strConnect ' it is in the ConnectDatabase.asp file
Dim strConnectXLS1 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS2 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS3 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS4 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS5 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS6 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS7 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS8 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS9 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS10 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS11 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS12 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS13 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS14 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS15 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS16 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS17 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS18 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS19 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS20 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS21 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS22 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS23 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS24 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS25 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS26 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS27 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS28 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS29 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS30 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS31 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS32 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS33 ' it is in the ConnectDatabase.asp file
Dim strConnectXLS34 ' it is in the ConnectDatabase.asp file
Dim availability
Dim aobjRSXLS1(40000)
Dim aobjRSXLS2(35000)
Dim aobjRSXLS3(6000)
Dim aobjRSXLS4(4000)
Dim aobjRSXLS5(1000)
Dim aobjRSXLS6
Dim aobjRSXLS7(2000)
Dim aobjRSXLS8(3500)
Dim aobjRSXLS9(200)
Dim aobjRSXLS10(5000)
Dim aobjRSXLS11(5500)
Dim aobjRSXLS12(5000)
Dim aobjRSXLS13(1500)
Dim aobjRSXLS14(500)
Dim aobjRSXLS15(200)
Dim aobjRSXLS16(2000)
Dim aobjRSXLS17(600)
Dim aobjRSXLS18(40000)
Dim aobjRSXLS19(500)
Dim aobjRSXLS20(2500)
Dim aobjRSXLS21(500)
Dim aobjRSXLS22(6000)
Dim aobjRSXLS23(250)
Dim aobjRSXLS23_2(250)
Dim aobjRSXLS24(1000)
Dim aobjRSXLS25(160)
Dim aobjRSXLS26(100)
Dim aobjRSXLS27(100)
Dim aobjRSXLS28(1000)
Dim aobjRSXLS29(7000)
Dim aobjRSXLS30(100)
Dim aobjRSXLS31(200)
Dim aobjRSXLS32(200)
Dim aobjRSXLS33(500)
Dim aobjRSXLS34(500)
Dim objRSXLS1
Dim objRSXLS2
Dim objRSXLS3
Dim objRSXLS4
Dim objRSXLS5
Dim objRSXLS6
Dim objRSXLS7
Dim objRSXLS8
Dim objRSXLS9
Dim objRSXLS10
Dim objRSXLS11
Dim objRSXLS12
Dim objRSXLS13
Dim objRSXLS14
Dim objRSXLS15
Dim objRSXLS16
Dim objRSXLS17
Dim objRSXLS18
Dim objRSXLS19
Dim objRSXLS20
Dim objRSXLS21
Dim objRSXLS22
Dim objRSXLS23
Dim objRSXLS23_2
Dim objRSXLS24
Dim objRSXLS25
Dim objRSXLS26
Dim objRSXLS27
Dim objRSXLS28
Dim objRSXLS29
Dim objRSXLS30
Dim objRSXLS31
Dim objRSXLS32
Dim objRSXLS33
Dim objRSXLS34
Set objRSXLS1 =Server.CreateObject("ADODB.recordset")
Set objRSXLS2 =Server.CreateObject("ADODB.recordset")
Set objRSXLS3=Server.CreateObject("ADODB.recordset")
Set objRSXLS4=Server.CreateObject("ADODB.recordset")
Set objRSXLS5=Server.CreateObject("ADODB.recordset")
Set objRSXLS6=Server.CreateObject("ADODB.recordset")
Set objRSXLS7=Server.CreateObject("ADODB.recordset")
Set objRSXLS8=Server.CreateObject("ADODB.recordset")
Set objRSXLS9=Server.CreateObject("ADODB.recordset")
Set objRSXLS10=Server.CreateObject("ADODB.recordset")
Set objRSXLS11=Server.CreateObject("ADODB.recordset")
Set objRSXLS12=Server.CreateObject("ADODB.recordset")
Set objRSXLS13=Server.CreateObject("ADODB.recordset")
Set objRSXLS14=Server.CreateObject("ADODB.recordset")
Set objRSXLS15=Server.CreateObject("ADODB.recordset")
Set objRSXLS16=Server.CreateObject("ADODB.recordset")
Set objRSXLS17=Server.CreateObject("ADODB.recordset")
Set objRSXLS18=Server.CreateObject("ADODB.recordset")
Set objRSXLS19=Server.CreateObject("ADODB.recordset")
Set objRSXLS20=Server.CreateObject("ADODB.recordset")
Set objRSXLS21=Server.CreateObject("ADODB.recordset")
Set objRSXLS22=Server.CreateObject("ADODB.recordset")
Set objRSXLS23=Server.CreateObject("ADODB.recordset")
Set objRSXLS23_2=Server.CreateObject("ADODB.recordset")
Set objRSXLS24=Server.CreateObject("ADODB.recordset")
Set objRSXLS25=Server.CreateObject("ADODB.recordset")
Set objRSXLS26=Server.CreateObject("ADODB.recordset")
Set objRSXLS27=Server.CreateObject("ADODB.recordset")
Set objRSXLS28=Server.CreateObject("ADODB.recordset")
Set objRSXLS29=Server.CreateObject("ADODB.recordset")
Set objRSXLS30=Server.CreateObject("ADODB.recordset")
Set objRSXLS31=Server.CreateObject("ADODB.recordset")
Set objRSXLS32=Server.CreateObject("ADODB.recordset")
Set objRSXLS33=Server.CreateObject("ADODB.recordset")
Set objRSXLS34=Server.CreateObject("ADODB.recordset")
Const ForWriting = 2 ' Input OutPut mode
Const Create = True
Const ForAppending = 8
Dim MyFile
Dim FSO ' FileSystemObject
Dim TSO ' TextStreamObject
MyFile = Server.MapPath("deleted_products.txt")
%>