连接数据库时显示类型不符

来源:百度知道 编辑:UC知道 时间:2024/06/15 11:50:55
用ASP读取access数据库是总显示错误信息为类型不符

<%

UserName = trim(Request.form("UserName"))
Title = trim(Request.form("Title") )
Content = Request("Content")
CurrentTime = Now()

set objRS =server.createobject("adodb.recordset")

Set objRS =GetRecordset("book.mdb","留言板")
objRS.AddNew Array("作者","主题","内容","时间"), _
Array("&UserName&","&Title&","&Content&","&CurrentTime&")
objRS.Update

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing

Response.Redirect "NEWSGROUP.ASP"
%>

错误类型:
Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配: 'GetRecordset'
/CH12/NEWS/Post.asp, 第 14 行

浏览器类型:
Mozilla/4.0 (comp

UserName = trim(Request.form("UserName"))
Title = trim(Request.form("Title") )
Content = Request("Content")
CurrentTime = Now()
POST方法?
Content = Request("Content") 这一句是不是Content = Request.form("Content")?
这时用GET传值是没用的

看看你的数据类型是否正确 时间是不是DATE类型的