注册 登录
编程论坛 新人交流区

[求助]conn.execute exec出错

cy11423 发布于 2007-10-19 14:40, 492 次点击

<%
set conn=server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("guestbook.mdb")
name=request.form("name")
tel=request.form("tel")
message=request.form("message")
exec="insert into gustbook(name,tel,message) values ('"&name&"',"&tel&",'"&message&"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
____________________________________________________________________________
错误提示:
错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
________________________________________________________________________-___

哪位高手知道该怎么解决啊,急啊!!!!!!!!!!


[此贴子已经被作者于2007-10-19 14:41:18编辑过]

0 回复
1