调试结果如下
ADODB.Recordset 错误 '800a0bb9'
参数类型不正确,或不在可以接受的范围之内,或与其他参数冲突。
/stamps/Connections/add.asp,行 25
————————————————————————
部分代码:
————————————————————
dim filePath
dim oRs
dim names
dim emails
dim notes
dim dates
names=Request.Form("text1"
emails=Request.Form("text2"
notes=Request.Form("text3"
set cn=Server.CreateObject("ADODB.Connection"
filePath=Server.MapPath("book.mdb"
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
Set oRs=Server.CreateObject("ADODB.RecordSet"
oRs.Open"notes",cn,adOpenDynamic,adLockOptimistic //第25行代码
oRs.AddNew
oRs("name"
=names
oRs("email"
=emails
oRs("note"
=notes
oRs("date"
=Now
oRs.Update
oRs.Close
Set oRs=Nothing
cn.Close
set cn=Nothing
Response.Redirect("note.asp"