注册 登录
编程论坛 ASP技术论坛

为什么 我写了rs=nothing 报错:“对象变量未设置”

bianjinhui 发布于 2016-07-02 21:12, 4306 次点击
        set rs=server.CreateObject("ADODB.recordset")
            sql="select * from login where user='"&user&"' and pwd='"&pwd&"'"
            rs.open sql,conn,1,1
    if not rs.eof then
               rs.close
               response.Write(index_loginmsgd)
               response.End()
        else
               rs.close
               rs.open "select * from login",conn,1,3
               rs.addnew
               rs("user")=user
               rs("pwd")=pwd
               rs("username")=username
               rs("tel")=tel
               rs.update
               rs.close
               rs=nothing
               rs=nothing
               response.Write(index_loginmsge)
    end if
3 回复
#2
hu9jj2016-07-03 16:45
以下是引用bianjinhui在2016-7-2 21:12:45的发言:

        set rs=server.CreateObject("ADODB.recordset")
            sql="select * from login where user='"&user&"' and pwd='"&pwd&"'"
            rs.open sql,conn,1,1
    if not rs.eof then
               rs.close
               response.Write(index_loginmsgd)
               response.End()
        else
               rs.close
               rs.open "select * from login",conn,1,3
               rs.addnew
               rs("user")=user
               rs("pwd")=pwd
               rs("username")=username
               rs("tel")=tel
               rs.update
               rs.close
               rs=nothing
               rs=nothing
               response.Write(index_loginmsge)
    end if

没有发现多出了一行rs=nothing吗?
#3
qq8217412512016-07-19 11:23
1.set rs=nothing
2.包含的sql语句内不能使用同一个变量rs。内部的rs需要写成其他变量。如mrs等
#4
孤独冷雨2016-11-01 18:00
else
       rs.close

把这个rs.close删了
1