到底出了什么问题？

MessiahLS 2003-08-20 11:01:13

<html>
<head>
<title>管理-添加新闻</title>
</head>
<body>
<%
if request.form("submit") = 1 then
 '此文件建立ADODB.Connection对象conn
set rsNews = Server.CreateObject("ADODB.RecordSet")
rsNews.open "SELECT * FROM News",conn,adOpenDynamic,adLockOptimistic
'rsNews.AddNew
'rsNews("title") = Cstr(request.form("title"))
'rsNews("source") = Cstr(request.form("source"))
'rsNews("content") = Cstr(request.form("content"))
'rsNews("type") = Cint(request.form("typeid"))
'rsNews.Updata
response.write "添加成功!"
response.Redirect "xxx.asp"
rsNews.close
set rsNews = nothing
 '此文件关闭conn
else
%>
<form id = "addnews" runat = "server" action = "AddNews.asp" method = "POST" >
标题:<input type = text name = title><br>
来源:<input type = text name = source><br>
类型: <input type = radio name = typeid value = 1>新闻 <input type = radio name = typeid value = 2>公告 <br>
内容:<textarea name = content rows = 8 cols = 40></textarea><br>
<input type = hidden name = submit value = 1>
<input type = submit value = 提交>
<input type = reset value = 重写>
</form>
<%
end if
%>
</body>

</html>

运行后，提示错误为
ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/AddNews.asp, line 11

为何原因？大家救救我吧！

...全文

29 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

好记忆不如烂笔头abc 2003-08-20

打赏
举报

'rsNews.AddNew
'rsNews("title") = Cstr(request.form("title"))
'rsNews("source") = Cstr(request.form("source"))
'rsNews("content") = Cstr(request.form("content"))
'rsNews("type") = Cint(request.form("typeid"))
'rsNews.Updata

你怎么注释了呢？＝＝》
rsNews.AddNew
rsNews("title") = Cstr(request.form("title"))
rsNews("source") = Cstr(request.form("source"))
rsNews("content") = Cstr(request.form("content"))
rsNews("type") = Cint(request.form("typeid"))
rsNews.Updata

MessiahLS 2003-08-20

打赏
举报

不行呀！！！高人快点帮帮忙呀！

coffee_cn 2003-08-20

打赏
举报

换成这样试：

conn.execute "update News set title='"&request.form("title")&"',source='"&request.form("source")&"',content='"&request.form("content")&"',type="&request.form("typeid")&""

如果还是不行，那要看看数据库了

junsisi 2003-08-20