Function ProTest(UserID)
dim rs, sql
set rs = Server.CreateObject("adodb.recordset")
sql = "select paytype from Cl_User where userid= "&UserID&""
rs.open sql, conn, 1, 1
dim paytype, arr
paytype = rs("paytype")
arr = split(paytype,",")
dim i, rsp, sqlp, FinishDate, inpaytype, outpaytype
for i = lbound(arr) to ubound(arr) step 1
set rsp = Server.CreateObject("adodb.recordset")
sqlp = "select top 1 FinishDate from Cl_PayLog where userid = "&UserID&" and ProId = "&arr(i)&" order by FinishDate desc"
rsp.open sqlp, conn, 1, 1 if rsp.eof or rsp.bof then
outpaytype=outpaytype + arr(i) + ","
else
if Datediff("d",rsp("FinishDate"),now())<=0 then
inpaytype = arr(i)+ ","
else
outpaytype = arr(i)+","
end if
end if
rsp.close
set rsp = nothing
next
rs.close
set rs =nothing
Response.Write("您的以下产品还可以使用,<br>")
Response.Write(inpaytype&"<br>")
Response.Write("您的以下产品已经过期<br>")
Response.Write(outpaytype)
End Function这段代码在哪里有错误啊?
Microsoft VBScript 编译器错误 错误 '800a03f6' 缺少 'End'
dim rs, sql
set rs = Server.CreateObject("adodb.recordset")
sql = "select paytype from Cl_User where userid= "&UserID&""
rs.open sql, conn, 1, 1
dim paytype, arr
paytype = rs("paytype")
arr = split(paytype,",")
dim i, rsp, sqlp, FinishDate, inpaytype, outpaytype
for i = lbound(arr) to ubound(arr) step 1
set rsp = Server.CreateObject("adodb.recordset")
sqlp = "select top 1 FinishDate from Cl_PayLog where userid = "&UserID&" and ProId = "&arr(i)&" order by FinishDate desc"
rsp.open sqlp, conn, 1, 1 if rsp.eof or rsp.bof then
outpaytype=outpaytype + arr(i) + ","
else
if Datediff("d",rsp("FinishDate"),now())<=0 then
inpaytype = arr(i)+ ","
else
outpaytype = arr(i)+","
end if
end if
rsp.close
set rsp = nothing
next
rs.close
set rs =nothing
Response.Write("您的以下产品还可以使用,<br>")
Response.Write(inpaytype&"<br>")
Response.Write("您的以下产品已经过期<br>")
Response.Write(outpaytype)
End Function这段代码在哪里有错误啊?
Microsoft VBScript 编译器错误 错误 '800a03f6' 缺少 'End'
解决方案 »
- Windows Mobile编程环境安装问题!
- 数据库查询语句(在线等待)
- c# 文件追加数据
- 寻求OA,要求见帖,见面演示并且本人认可之后付费交易,详见帖内容,同时请版主手下留情,稍后我转到非技术中
- 这么简单的问题,究竟错在哪里?
- 怎样修改控件移动的尺寸?
- 新建一项目,又添加一窗口,问:如何使 Form2.cs为启动窗口?
- 求助,c#中怎么样把form上的控件值传递给报表中的控件
- 本人免费提供ASPSIR.COM的二级域名,快来抢呀!
- 请指点
- 请问在.net2005下水晶报表怎么实现 批量邦定数据?? 我想把dataset的每行数据循环邦定到报表上 急。。。在线等
- access数据库,我想初始化表里面的数据怎么做啊?
outpaytype=outpaytype + arr(i) + ","
else
if Datediff("d",rsp("FinishDate"),now()) <=0 then
inpaytype = arr(i)+ ","
else
outpaytype = arr(i)+","
end if
end if
rsp.close
set rsp = nothing
next
set rsp = Server.CreateObject("adodb.recordset")
sqlp = "select top 1 FinishDate from Cl_PayLog where userid = "&UserID&" and ProId = "&arr(i)&" order by FinishDate desc"
rsp.open sqlp, conn, 1, 1 if rsp.eof or rsp.bof then
outpaytype=outpaytype + arr(i) + ","
else
if Datediff("d",rsp("FinishDate"),now()) <=0 then
inpaytype = arr(i)+ ","
else
outpaytype = arr(i)+","
end if
end if
rsp.close
set rsp = nothing
next
end
for 循环少了end
快忘干净了