Microsoft JET Database Engine 错误 '80040e14' INSERT INTO 语句的语法错误。
来源:百度知道 编辑:UC知道 时间:2024/07/02 22:47:02
Microsoft JET Database Engine 错误 '80040e14' INSERT INTO 语句的语法错误。
我的代码:
<!-- #include file="ADOFunctions.inc" -->
<%
user=trim(request("username"))
password=trim(request("userpwd"))
password1=trim(request("userpwd1"))
if user="" or password="" or password1="" then
response.write"用户名或密码不能为空<a href='newuser.asp'>返回</a>"
response.end
end if
if password=trim(request("userpwd"))<>password=trim(request("userpwd1")) then
response.write"密码和确认密码不一致<a href='newuser.asp'>返回</a>"
response.end
end if
selsql="select * from [user] where yonghu='"&user&"' and pwd='"&password&"'"
set ad=objconn.execute(selsql)
' Set ad=Server.CreateObject("ADODB.Recordset")
' ad.open selsql,ob
我的代码:
<!-- #include file="ADOFunctions.inc" -->
<%
user=trim(request("username"))
password=trim(request("userpwd"))
password1=trim(request("userpwd1"))
if user="" or password="" or password1="" then
response.write"用户名或密码不能为空<a href='newuser.asp'>返回</a>"
response.end
end if
if password=trim(request("userpwd"))<>password=trim(request("userpwd1")) then
response.write"密码和确认密码不一致<a href='newuser.asp'>返回</a>"
response.end
end if
selsql="select * from [user] where yonghu='"&user&"' and pwd='"&password&"'"
set ad=objconn.execute(selsql)
' Set ad=Server.CreateObject("ADODB.Recordset")
' ad.open selsql,ob
nsql="insert into user(yonghu,pwd) value('"&user&"','"&password&"')"
改成
nsql="insert into [user](yonghu,pwd) values('"&user&"','"&password&"')"
老兄。两个错误
1 你查询的时候知道user要加[] 为什么插入就忘记了呢?
2 插入是insert values 而你现在是value
nsql="insert into user(yonghu,pwd) value('"&user&"','"&password&"')"
改成
nsql="insert into user(yonghu,pwd) values('"&user&"','"&password&"')"
Microsoft Jet打不开文件
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E07) asp
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80004005)错误
Microsoft Jet 数据库引擎打不开文件