这是什么问题????非常急!!!
错误类型:
ADODB.Recordset (0x800A0E78)
adErrObjectClosed 3704
0x800A0E78
如果对象关闭,则不允许应用程序请求的操作
Trs.Open sql,conn,1,1
'x=1
while Trs.EOF <>true
sql="select Memo_ID from Corp_SIM_Type where Time_ID="&Time_ID&" and Capability_ID="&Trs("Capability_ID")&" order by Memo_ID"
PRs.Open sql,conn,1,1
if PRS.BOF and PRs.EOF then
else
while PRs.EOF <>true
Comm1("@Vendor_ID")=Vendor_ID
Comm1("@Time_ID")=trim(Time_ID)
Comm1("@Cap_ID")=Trs("Capability_ID")
Comm1("@Memo_ID")=PRs("Memo_ID")
set TSRs=comm1.Execute
if TSRs.BOF and TSRs.EOF then --为什么这一句报上面那个错误呢? %>
<td></td>
<td></td>
<%
else
%>
<td><%=TSRs("Price")%></td>
<td></td>
<%
end if
TSRs.Close()
set TSRs=nothing
PRs.MoveNext
'x=x+1
wend
end if
PRs.Close()
Trs.MoveNext
wend
Trs.Close()