Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/mjrjjb3/conn1.asp,行 32
我的代码是这样:
<style type="text/css">
<!--
.style4 {font-size: 24px}
.style5 {font-size: 18px}
-->
</style>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="283" height="106" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="32" bgcolor="#CCCCCC"><div align="center"><span class="style4">操作:留言成功!</span></div></td>
</tr>
<tr>
<td><div align="center"><span class="style5"> 谢谢你的留言!!!</span></div></td>
</tr>
<tr>
<td><div align="center"><span class="style5"><a href="javascript:onclick=history.go(-1)">返回</a></span></div></td>
</tr>
</table>
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("my.mdb")
username=request.form("USERNAME")
tel=request.form("PHONE")
content=request.form("TEXT")
email=request.form("EMAIL")
exec="insert into leaves (name,tel,qq,contents) values ('"+username+"',"+tel+",'"+email+"','"+content+"')"
conn.execute exec 〈就这行说错了!!〉
conn.close
set conn=nothing
%>