28,391
社区成员
发帖
与我相关
我的任务
分享
<%
for i=1 to 10000
'取得商务一部的当月目标
set rsO1=server.CreateObject("adodb.recordset")
sqlO1="select * from Operation where UserId=1000 and OperationDate=#"&cdate(year(date())&"-"&month(date()))&"#"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
target1=rsO1("target")
end if
rsO1.close():set rsO1=nothing
next
conn.close():set conn=nothing
%>
set rsO1=server.CreateObject("adodb.recordset")
for i=1 to 10000 '取得商务一部的当月目标
sqlO1="select * from Operation where UserId=1000 and OperationDate=#"&cdate(year(date())&"-"&month(date()))&"#"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
target1=rsO1("target")
end if
next
rsO1.close():set rsO1=nothing
conn.close():set conn=nothing
<%
Response.Write(now())
set rsO1=server.CreateObject("adodb.recordset")
sqlO1="SELECT * FROM [user]"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
Response.Write(" ")
end if
rsO1.close
set rsO1=nothing
conn.close():set conn=nothing
Response.Write("<br>")
Response.Write(now())
%>
<%
Response.Write(now())
set rsO1=server.CreateObject("adodb.recordset")
for i=1 to 10000 '取得商务一部的当月目标
sqlO1="select * from Operation where UserId=1000 and OperationDate LIKE '%"&cdate(year(date())&"-"&month(date()))&"%'"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
target1=rsO1("target")
end if
rsO1.close
next
set rsO1=nothing
conn.close():set conn=nothing
Response.Write("<br>")
Response.Write(now())
%>
set rsO1=server.CreateObject("adodb.recordset")
for i=1 to 10000 '取得商务一部的当月目标
sqlO1="select * from Operation where UserId=1000 and OperationDate LIKE '%"&cdate(year(date())&"-"&month(date()))&"%'"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
target1=rsO1("target")
end if
rsO1.close
next
set rsO1=nothing
conn.close():set conn=nothing
set rsO1=server.CreateObject("adodb.recordset")
for i=1 to 10000 '取得商务一部的当月目标
sqlO1="select * from Operation where UserId=1000 and OperationDate=#"&cdate(year(date())&"-"&month(date()))&"#"
rsO1.open sqlO1,conn,1,1
if not rsO1.eof then
target1=rsO1("target")
end if
rsO1.close
next
set rsO1=nothing
conn.close():set conn=nothing