<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
这个问题出在哪?哪位能帮我修正下再发回来谢谢,高分在线等。。顶者有分
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook(name,tel,message)values('"+name+"',"+tel+",'"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
这个问题出在哪?哪位能帮我修正下再发回来谢谢,高分在线等。。顶者有分
可能message能容太大了。
用recordset update试试
name=request.form("name")
tel=request.form("tel")
message=request.form("message") 是否能够取到正确的数据;
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。
/example5.asp, 第 19 行这是错误信息。你们对照下这程序错在哪。
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head><body>
<form name="form1" method="post" action="example5.asp">
<p>name:
<input type="text" name="name">
tel:
<input type="text" name="tel">
message
<input type="text" name="message" value="">
</p>
<p> <input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
<br>
</p>
</form>
</body>
</html>你看下。我也不清楚
运行时有什么提示错误呢?
你看看这样行不行
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook (name,tel,message) values ('" &name &"'," &tel &"','" &message &"')"
conn.execute(exec)
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
无效字符
/example5.asp, line 17, column 12
conn.execute(exec)
-----------^我换成了你帮我改的。错误信息就是这样的了
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq=" &server.mappath("example3.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into guestbook (name,tel,message) values ('" &name &"','" &tel &"','" &message &"')"
conn.execute(exec)
conn.close
set conn=nothing
response.write "记录添加成功!"
%>