Question

参数不足,期待是 1。各位ASP的精英们,前辈们,求助,一直报错,信息和代码如下:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
/wwwroot/example10/asp/add.asp, 第 6 行

1 set conn=server.createobject("adodb.connection")
2 conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("test.mdb")
3 aa=request.form("aa")
4 bb=request.form("bb")
5 exec="insert into test(aa,bb)values("+aa+",'"+bb+"')"
6 conn.execute exec
7 conn.close
8 set conn=nothing
9 response.redirect "list.asp"

我页面的:
<form name="form1" method="post" action="add.asp">
<p>aa
<input type="text" name="aa">
</p>
<p>bb
<input type="text" name="bb">
</p>
<input type="submit" name="Submit" value="提交">
</form>

求助,谢谢各位!!!!!!!!!!!!!!11

Answer 1

建议你啊 不要偷懒还是用记录集的方式来完成吧。从第五行开始:
Set Rs=Server.CreateObject("ADODB.Recordset")
Rs.Open "Insert Into Test(列名) values("+值+")" 如果是字符建议加('"+值+"'),Conn,1,3
Conn.Close()
Set Conn=Nothing
跳转

Answer 2

set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("test.mdb")
aa=trim(request.form("aa"))
bb=(request.form("bb"))
Set Rs=Server.CreateObject("ADODB.Recordset")
exec="insert into test(aa,bb)values("&aa&",'"&bb&"')"
Rs.Open exec,Conn,1,3
rs.colse
set rs=nothing
conn.close
set conn=nothing
response.redirect "list.asp"

Answer 3

1 set conn=server.createobject("adodb.connection")
2 conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("test.mdb")
3 aa=request.form("aa")
4 bb=request.form("bb")
5 if aa<>"" and bb<>"" then
6 exec="insert into test(aa,bb)values("&aa&",'"&bb&"')"
6 conn.execute exec
7 End if
8 conn.close
8 set conn=nothing
9 response.redirect "list.asp"