[求助]conn.execute exec出错
<%
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编辑过]