ADODB.Recordset 错误 '800a0e78' ???????大侠 有代码
jj_79 2001-12-01 08:51:48 我在ASP 中调用存储过程(在查询器中已通过)时出现ADODB.Recordset 错误 '800a0e78' 错误,代码如下:
Set Conn = Server.CreateObject("ADODB.Connection")
CONN.Open application("connstring")
strSQL = "ttt'" & session("session_monitor_type") & "','" & session("session_flag_i_e") & "','" & session("session_start_date") & "','"&session("session_end_date")&"'"
set rs1=Server.CreateObject("ADODB.RecordSet")
rs1.close
rs1.CursorLocation =3
rs1.open strSQL,conn,1,1(上面可以通过)
while not rs.eof
<td height="17" width="11%" class="hui_mid_tr"> <%'=count_id%></td>
<td height="17" width="19%" class="hui_mid_tr"> <a href="entry.asp?entryid=<%=rs1("form_id")%>"><%'=rs1("form_id")%></a></td>
<td height="17" class="hui_mid_tr" width="23%"><%=rs1("xgl")%></td>
<td height="17" class="hui_mid_tr" width="21%"> <%=rs1("xgv")%></td>
<td height="17" width="26%" class="hui_mid_tr"> <%=rs1("agent")%></td>
rs1.movenext
loop%>
</table>
<%rs.close
set rs=nothing
conn.close
set conn=nothing
%>