ASP连接SQL语法错误

来源：百度知道编辑：UC知道时间：2024/07/04 02:29:05

<% dim username,userpwd,email,nRegisterTime,safecode,nick
username=Trim(Request.Form("username"))
userpwd=Trim(Request.Form("userpwd"))
email=Trim(Request.Form("email"))
safecode=clng(Trim(Request.Form("safecode")))
nick=Trim(Request.Form("nick"))
if safecode<>session("checkNum") then
Response.Write "<script>alert('验证码错误,请重新填写!');window.location='reg.asp';</script>"
Response.end
end if
nRegisterTime=datediff("s",cdate("1970-01-01 00:00:00"),date())
Set rs1=Server.CreateObject("adodb.recordSet")
rs1.open "Select * from UserBrief where username='"&username&"'",conn
if rs1.eof and rs1.bof then
Set rs=Server.CreateObject("adodb.recordSet")
rs.open "Select max(uin) as uinm

conn.execute"insert into UserBrief(username,Password,email,nRegisterTime,uin,Nick,nparent) values('"&username&"','"&userpwd&"','"&email&"',"&nRegisterTime&","&rs("uinmax")+1&",'"&nick&"'15000000"&"')"

就是这句,username,Password,email,三个字段没问题，之后的有问题,
nRegisterTime对应的应是'"&nRegisterTime&"' uin对应的是'"&rs("uinmax")+1&"',Nick对应的是'"&nick&"',那么nparent对应的是哪个值?是 15000000??很明显的sql语法错误.如果是的话,15000000前面至少要有个","

ASP连接SQL语法错误 asp的access转sql语法错误 asp.net连接sql asp+ms sql连接 ASP连接SQL asp连接sql数据库 SQL连接问题ASP ASP连接 MY SQL asp连接SQL server?! asp连接sql