rs.open sql,conn,1,3 出错

来源:百度知道 编辑:UC知道 时间:2024/06/19 12:32:52
admin_name=trim(request.form("admin_name"))
admin_password=trim(request.form("admin_password"))
guestbook_id=request.querystring("guestbookId")
guestbook_reply_content=txttourl(request.form("guestbook_reply_content"))
guestbook_sign=request.form("guestbook_sign")
if(admin_password="") then
call msgbox("您没有输入管理员的密码!是非法操作!","new_guest_book.asp?action=reply&guestbookId="&guestbook_id)
else
set rsAdmin=server.createobject("adodb.recordset")
sql="select * from admin where admin_name='"&admin_name&"' and admin_password='"&admin_password&"'"
rsAdmin.open sql,conn,1,1
if(rsAdmin.eof and rsAdmin.eof) then
call msgbox("您输入管理员用户名与密码错误!请重新输入!","new_guest_book.asp?action=reply&guestbookId="&guestbook_id)
else

rsAdmin.close
set rsAdmin=no

是否有set rs=server.createobject("adodb.recordset")

你的rs对象没有创建
怎么能操作?

rsAdmin.close
set rsAdmin=nothing
rsAdmin也已经关闭释放了呀

重新创建一个