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

你这是asp吧?
连接是&干嘛用+
哦,+好像也是对的

不知道是不是遇到数字会出现加操作造成的,试试改成&连接吧

sql语句上看不出什么语法错误

够狠