UC知道ASP+ACCESS INSERT INTO 语句的语法错误
来源：百度知道 编辑：UC知道 时间：2024/05/27 16:36:10
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
db="conn.mdb"
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
set conn= Server.CreateObject("Adodb.connection")
conn.open connstr
dim sAddr
sAddr = Request.ServerVariables("REMOTE_ADDR")
conn.execute("insert into count(vUser,vDate) values('ceshi','"& Date() &"','"& sAddr &"')")
rs.close
conn.close()
Set conn=nothing
%>
<%
db="conn.mdb"
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
set conn= Server.CreateObject("Adodb.connection")
conn.open connstr
dim sAddr
sAddr = Request.ServerVariables("REMOTE_ADDR")
conn.execute("insert into count(vUser,vDate) values('ceshi','"& Date() &"','"& sAddr &"')")
rs.close
conn.close()
Set conn=nothing
%>
conn.execute("insert into count(vUser,vDate) values('ceshi','"& Date() &"','"& sAddr &"')")
前面两个字段，后面三个字段肯定不行啊！！！
还有，你的表count是关键字。最好少用！