INSERT INTO 语句语法错误?
来源:百度知道 编辑:UC知道 时间:2024/05/31 09:54:08
if bname="" or bcomp="" then
Response.Write("<script>alert(""错误:\信息输入不完全,请重新输入完整!"&Copyright&""");location.href=""jb.htm"";</script>")
else
set rs1 = server.createobject("adodb.recordset")
sql1="select * from cont "
rs1.open sql1,conn,1,3
exec="insert into cont(password,fyname,fycomp,fyjob,fyphone,bname,fyarea,bcomp,bjob,bsyst,bgrade,cont)values('"+password+"','"+fyname+"','"+fycomp+"','"+fyjob+"','"+fyphone+"','"+bname+"','"+fyarea+"','"+bcomp+"','"+bjob+"','"+bsyst+"','"+bgrade+"','"+cont+"')"
conn.execute exec
conn.close
set conn=nothing
Response.Write("<script>ale
Response.Write("<script>alert(""错误:\信息输入不完全,请重新输入完整!"&Copyright&""");location.href=""jb.htm"";</script>")
else
set rs1 = server.createobject("adodb.recordset")
sql1="select * from cont "
rs1.open sql1,conn,1,3
exec="insert into cont(password,fyname,fycomp,fyjob,fyphone,bname,fyarea,bcomp,bjob,bsyst,bgrade,cont)values('"+password+"','"+fyname+"','"+fycomp+"','"+fyjob+"','"+fyphone+"','"+bname+"','"+fyarea+"','"+bcomp+"','"+bjob+"','"+bsyst+"','"+bgrade+"','"+cont+"')"
conn.execute exec
conn.close
set conn=nothing
Response.Write("<script>ale
你这是asp吧?
连接是&干嘛用+
哦,+好像也是对的
不知道是不是遇到数字会出现加操作造成的,试试改成&连接吧
sql语句上看不出什么语法错误
够狠