麻烦看一下。很简单的问题+1

[MosquitoWeb]

<!-- #include file="bkconn.asp" -->
<%
if Request("memberID")="" then response.write "<script language=Javascript>alert('用户名不能为空！');window.history.go(-1);</script>"
sql="select * from member where memberID='" & trim(request("memberID")) & "' and Password='" & replace(trim(request("password")),"'","''") & "'"
'response.write sql
'response.End
set rs = conn.Execute(sql)
if not (rs.eof or err) then
session("selviceshopmemberID")=rs("memberID")
rs("hit")=rs("hit")+1 '问题在这里，不可以加1，对象或提供者不能执行所需的操作。
rs.update
if session("oldUrl")<>"" then
response.redirect session("oldUrl")
else
response.redirect "./"
end if
else
response.write "<script language=Javascript>alert('用户名或密码错误，请重新输入！');window.history.go(-1);</script>"
end if
%>

[jingxiaoping]

首先确认一下hit的类型，如果是数值型的才可以进行累加。

[coalsun]

conn.execute("update 表名 set hit=hit+1 where id="&id)

[MosquitoWeb]

我确定hit是数字类型的。
楼上的意思是说把我那句加一的换成你的吗？？
我试哈。

[csyu85]

这是因为没有修改的权限，使用conn.open sql,conn,1,3

[itzhiren]

<!-- #include file="bkconn.asp" -->
<%
if Request("memberID")="" then response.write "<script language=Javascript>alert('用户名不能为空！');window.history.go(-1);</script>"
sql="select * from member where memberID='" & trim(request("memberID")) & "' and Password='" & replace(trim(request("password")),"'","''") & "'"
'response.write sql
'response.End
set rs = server.createobject("adodb.recordset")
rs.open conn,sql,3,1
if not (rs.eof or err) then
session("selviceshopmemberID")=rs("memberID")
conn.execute("update 表名 set hit=hit+1 where memberID='" & trim(request("memberID")) & "' and Password='" & replace(trim(request("password")),"'","''") & "'")
if session("oldUrl")<>"" then
response.redirect session("oldUrl")
else
response.redirect "./"
end if
else
response.write "<script language=Javascript>alert('用户名或密码错误，请重新输入！');window.history.go(-1);</script>"
end if
%>

[MosquitoWeb]

对不起啊。还是不行啊。还是一样不能加一啊。

[ronakitty]

rs.open sql,conn,1,3
↑
注意是3呦

[MosquitoWeb]

变量或者类型不正确，或者不在可以接受的范围之内，要不就是与其他数据冲突。

[MosquitoWeb]

谢谢各位好心的帮忙，搞定了。下面是源代码：
<!-- #include file="bkconn.asp" -->
<%
memberID=Request("memberID")
if memberID="" then response.write "<script language=Javascript>alert('用户名不能为空！');window.history.go(-1);</script>"
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from member where memberID='" & trim(request("memberID")) & "' and Password='" & replace(trim(request("password")),"'","''") & "'"
'response.write sql
'response.End
'set rs = conn.Execute(sql)
rs.open sql,conn,1,3
'conn.execute("update member set hit=hit+1 where memberID="&memberID)
if not (rs.eof or err) then
session("selviceshopmemberID")=rs("memberID")
rs("hit")=rs("hit")+1
rs.update
if session("oldUrl")<>"" then
'response.redirect session("oldUrl")
hit=rs("hit")
response.write "成功了！"&memberID&hit
else
'response.redirect "./"
response.write "成功了！"
end if
else
response.write "<script language=Javascript>alert('用户名或密码错误，请重新输入！');window.history.go(-1);</script>"
end if
%>