关于ASP 参数不足

来源:百度知道 编辑:UC知道 时间:2024/05/13 23:36:33
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 3。

代码如下:
<!--#include file="conn.asp"-->
<%name=Replace(Request.Form("name"),"’","’’")
title=Replace(Request.Form("title"),"’","’’")
body=Replace(Request.Form("body"),"’","’’")
%>
<%if name="" or title="" or body="" then%>
请<a href="javascript:history.go(-1)">后退</a>填写完整资料,你才能发表帖子!
<%else%>
<%set savebbs=conn.execute("insert into bbs(name,title,body)values(’"&name&"’,’"&title&"’,’"&body&"’)")%>
发表成功!<a href="index.asp">查看帖子</a>
<%end if
set savebbs=nothing
%>

数据库连接代码如下:
<%
Server.scriptTimeout="10"
conn

<%
name=Replace(Request.Form("name"),"’","’’")
title=Replace(Request.Form("title"),"’","’’")
body=Replace(Request.Form("body"),"’","’’")
if name="" or title="" or body="" then
response.write "请<a href=""javascript:history.go(-1)"">后退</a>填写完整资料,你才能发表帖子! "
else
set rs=server.createobject("adodb.recordset")
sql="select * from bbs"
rs.open sql,conn,2,3
rs.addnew
rs("name")=name
rs("title")=title
rs("body")=body
rs.update
response.write "发表成功!<a href=""index.asp"">查看帖子</a> "
end if
set rs=nothing
%>

数据库连接代码有错误,缺少参数,标准连接代码请按如下代码进行参考:

<%
'建立与***数据库的连接:
Set Conn=Server.CreateObject("ADODB.Connection"