Question

asp 更新数据，参数不足,期待是 1，怎么解决啊？

我的程序出下如下错误：
Microsoft OLE DB Provider for ODBC Drivers '80040e10'
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
\web\user.asp, line 7

程序代码是：
<%
session("user_id")="hy"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("data/data.mdb")
exec1="select * from user where account="&session("user_id")
set rs=server.createobject("adodb.recordset")
rs.open exec1,conn,1,3
rs("score")=30
rs("money")=30
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
望哪位大侠帮我指点一下。万分感谢。

Answer 1

原因如下,你的exec1="select * from user where account="&session("user_id")
没有取到值!

首先,你确定account字段是什么数据类型的,如果是数字,
exec1="select * from user where account="&cint(session("user_id"))

,如果是字符串,必须这样:
exec1="select * from user where account='"&session("user_id")&"'"

Answer 2

<%
dim DBName,conn,connstr
DBName="data/data.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBName)
conn.Open connstr

session("user_id")="hy"
set rs=server.createobject("adodb.recordset")
exec1="select * from user where account="&session("user_id")
rs.open exec1,conn,1,3
rs("score")=30
rs("money")=30
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>

Answer 3

session("user_id")为空值