请教一个问题,INSERT INTO 语句的语法错误
<%@Language=VBScript%>
<%
Dim Nick,Name1,Password,Email
Dim Province,City,Address,Zip,Phon
Nick=Trim(Request.Form("Nick"))
Name=Trim(Request.Form("Name"))
Password=Trim(Request.Form("Password"))
rePass=Trim(Request.Form("rePass"))
Email=Trim(Request.Form("Email"))
Province=Trim(Request.Form("Province"))
City=Trim(Request.Form("City"))
Address=Trim(Request.Form("Address"))
Zip=Trim(Request.Form("Zip"))
Phon=Trim(Request.Form("Phon"))
If Nick="" OR Name="" OR Password="" OR rePass="" OR Email="" OR Phon="" Then
ShowMessage "有必填项目没有填写!"
Set Conn=Nothing
Else
IF Password<>rePass then
ShowMessage "两次输入的密码不一样!"
set conn=nothing
end if
set conn=server.createobject("ADODB.CONNECTION")
P1="Provider=Microsoft.Jet.OLEDB.4.0;"
Path1="Data Source="&Server.MapPath("Users.mdb")
conn.open P1&Path1
set rs=Server.CreateObject("ADODB.Recordset")
sql="Select *From Users Where Nick="&Nick&""
rs.open sql,conn,0,1
if rs.eof and rs.bof then
sql="insert into Users (Nick,Password,Name,Email,Province,City,Address,Zip,Phon)"&"Values('"&Nick&"','"&Password&"','"&Name&"','"&Email&"','"&Province&"','"&City&"','"&Address&"','"&Zip&"','"&Phon&"')"
Conn.execute sql
rs.close
set rs=nothing
set conn=nothing
response.write"<center>祝贺你注册成功!"&"按<a href=Welcome.asp>这里</a>进入欢迎页面</center>"
else
rs.close
set rs=Nothing
set conn=nothing
ShowMessage "此登录名已被注册!"
end if
end if
%>
<!--显示返回重新填写信息的Sub过程:-->
<%Sub ShowMessage(msg)%>
<body bgcolor="#ccffff">
<center>
<h3><%=msg%></h3>
</center>
<form>
<p align="center">
<input type=Button Value="返回重新填写" OnClick="history.back();">
</p>
</form>
</body>
<% Response.End %>
<% End Sub%>
执行这些语句的老是提示出错,是什么原因呢?
谢谢!
出错提示是:Microsoft JET Database Engine 错误 '80040e14'
INSERT INTO 语句的语法错误。
/qing/Checkregi.asp,行 33
<%
Dim Nick,Name1,Password,Email
Dim Province,City,Address,Zip,Phon
Nick=Trim(Request.Form("Nick"))
Name=Trim(Request.Form("Name"))
Password=Trim(Request.Form("Password"))
rePass=Trim(Request.Form("rePass"))
Email=Trim(Request.Form("Email"))
Province=Trim(Request.Form("Province"))
City=Trim(Request.Form("City"))
Address=Trim(Request.Form("Address"))
Zip=Trim(Request.Form("Zip"))
Phon=Trim(Request.Form("Phon"))
If Nick="" OR Name="" OR Password="" OR rePass="" OR Email="" OR Phon="" Then
ShowMessage "有必填项目没有填写!"
Set Conn=Nothing
Else
IF Password<>rePass then
ShowMessage "两次输入的密码不一样!"
set conn=nothing
end if
set conn=server.createobject("ADODB.CONNECTION")
P1="Provider=Microsoft.Jet.OLEDB.4.0;"
Path1="Data Source="&Server.MapPath("Users.mdb")
conn.open P1&Path1
set rs=Server.CreateObject("ADODB.Recordset")
sql="Select *From Users Where Nick="&Nick&""
rs.open sql,conn,0,1
if rs.eof and rs.bof then
sql="insert into Users (Nick,Password,Name,Email,Province,City,Address,Zip,Phon)"&"Values('"&Nick&"','"&Password&"','"&Name&"','"&Email&"','"&Province&"','"&City&"','"&Address&"','"&Zip&"','"&Phon&"')"
Conn.execute sql
rs.close
set rs=nothing
set conn=nothing
response.write"<center>祝贺你注册成功!"&"按<a href=Welcome.asp>这里</a>进入欢迎页面</center>"
else
rs.close
set rs=Nothing
set conn=nothing
ShowMessage "此登录名已被注册!"
end if
end if
%>
<!--显示返回重新填写信息的Sub过程:-->
<%Sub ShowMessage(msg)%>
<body bgcolor="#ccffff">
<center>
<h3><%=msg%></h3>
</center>
<form>
<p align="center">
<input type=Button Value="返回重新填写" OnClick="history.back();">
</p>
</form>
</body>
<% Response.End %>
<% End Sub%>
执行这些语句的老是提示出错,是什么原因呢?
谢谢!
出错提示是:Microsoft JET Database Engine 错误 '80040e14'
INSERT INTO 语句的语法错误。
/qing/Checkregi.asp,行 33
...全文
相关推荐
excel文件中批量生成insert语句
excel文件中批量生成insert语句,为了初始化导入数据库里面的数据,如导入期初库存或者商品档案,员工数据等等
MySQL触发器 Update触发Insert失败
主要介绍了MySQL触发器 Update触发Insert失败 的相关资料,非常不错,具有参考借鉴价值,需要的朋友可以参考下
mysql语句如何插入含单引号或反斜杠的值详解
主要给大家介绍了关于mysql语句如何插入含单引号或反斜杠的值的相关资料,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面来一起学习学习吧
net insert into语法错误详解
问题描述:我用oledb的方式向access数据里写数据,示例源码如下: 代码如下:sql=”select * from multitable”;oledbdataadapter olesub=new oledbdataadapter(sql,olecn);oledbcommandbuilder cb1=new oledbcommandbuilder(olesub);dataset ds=new dataset();olesub.fill(ds.”multitable”);datatable dt=ds.tables[“multitable”];datarow dr=dt.newrow();d
sql无效字符 执行sql语句报错解决方案
说起来惭愧,在执行sql语句时总是犯一些小错误,纠结半天,这不应为一个分号的玩意折腾了好半天,需要了解的朋友可以参考下


