主题:数据库连接问题
我要在zhuce表中插入数据,但是出现了
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
下面是我的程序,帮忙看下,才能让数据库中插数据
dim conn
dim connstr
dim db
db="./database/canting.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.Open connstr
set rs=conn.execute("select * from zhuce where name='"&session("name")&"'")
if not rs.eof then
response.write("<script>alert(该数据已存在);history.go(-1);</script>")
response.end
else
conn.execute("insert into zhuce(name,password,realname,phone,email,address,notice) values("&name&","&password&","&realname&","&phone&","&email&","&address&","¬ice&")")
end if
%>
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
下面是我的程序,帮忙看下,才能让数据库中插数据
dim conn
dim connstr
dim db
db="./database/canting.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.Open connstr
set rs=conn.execute("select * from zhuce where name='"&session("name")&"'")
if not rs.eof then
response.write("<script>alert(该数据已存在);history.go(-1);</script>")
response.end
else
conn.execute("insert into zhuce(name,password,realname,phone,email,address,notice) values("&name&","&password&","&realname&","&phone&","&email&","&address&","¬ice&")")
end if
%>