为什么我的这个字段始终更新不了啊?

来源:百度知道 编辑:UC知道 时间:2024/03/28 19:59:14
<!--#include file="conn.asp"-->
<%
upid=request.form("upid")
set rs=server.createobject("adodb.recordset")
sql="select * from user where u_id='"&upid&"'" '更新记录定位
rs.open sql,conn,3,2
rs("u_refnumber")=trim(rs("u_refnumber")+1) 'u_refnumber更新的数字
rs.update
rs.close
%>
始终更新不了u_refnumber,请问,有哪位高手能指教下吗?

<%
upid=request.form("upid")
set rs=server.createobject("adodb.recordset")
sql = "UPDATE USER SET u_refnumber='" & trim(rs("u_refnumber")+1) & "' WHERE u_id='" & upid & "'"
rs.open sql,conn,1,1
msgbox "更新成功"
%>

rs.open sql,conn,3,2
改成 rs.open sql,conn,1,3
不过最好还是用SQL的修改语句进行修改
"UPDATE USER SET u_refnumber='" & trim(rs("u_refnumber")+1) & "' WHERE u_id='" & upid & "'"