请问为什么不能更新到access数据库 ASP？

Question

lid=session("id")
sql="select * from user where ID=cint('"&lid&"')"
set rs=server.createobject("adodb.recordset")
rs.open sql,connstr,1,3 
rs("sy")=request.form("times") 
rs.update
----------------------------------------------------------更新进ACCESS数据库

Answer 1

conn.execute("update user set sy='"&request("times")&"' where id='"&cint(session("id")&"'")试试。也可以输出来测试看lid=session("id")sql="select * from user where ID=cint('"&lid&"')"set rs=server.createobject("adodb.recordset")response.write sqlresponse.end()'在这里看看输出结果看看SQL的句子正常不正常。。。rs.open sql,connstr,1,3rs("sy")=request.form("times")rs.update