老是提示INSERT语句错误!各位大虾帮帮忙!
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/guest/addinfo.asp, 第 23 行
全部代码如下:
纯页面部分:guestinfo.asp
添加联系人信息处理程序如下:addinfo.asp
<%
dbpath=server.MapPath("datebase/db.mdb")
set db=server.CreateObject("adodb.connection")
conn="driver={microsoft access driver (*.mdb)};dbq="&dbpath
db.open conn
username=request("username")
mobeltelphone=request("mobeltelphone")
address=request("address")
work=request("work")
hometelphone=request("hometelphone")
officetelphone=request("officetelphone")
fax=request("fax")
email=request("email")
homepage=request("homepage")
intro=request("intro")
strsql="insert into info(username,mobeltelphone,address,work,hometelphone,officetelphone,fax,email,homepage,intro,note) values('"&username&"','"&mobeltelphone&"','"&address&"','"&work&"','"&hometelphone&"','"&officetelphone&"','"&fax&"','"&email&"','"&homepage&"','"&intro&"','"¬e&"')"
db.execute(strsql)
%>