Question

insert into 语句错误??急，可追加分数！

insert into reg(name,password,sex,email,address,time1,touxiang,homepage,content,oicq) values('"&name&"','"&pass&"',"&sex&",'"&email&"','"&address&"',#"&date1&"#,"&tou&",'"&homepage&"','"&content&"','"&qq&"')

上面是insert into语句
下面是全部
set rs=db.execute(sql)
if not rs.eof or not rs.bof then
response.write "您的用户名已经被注册 <a href=reg.asp>重新注册</a>"
response.end
else
pass=trim(request.form("password"))
sex=trim(request.form("sex"))
email=trim(request.form("email"))
qq=trim(request.form("qq"))
address=trim(request.form("address"))
tou=trim(request.form("tou"))
homepage=trim(request.form("homepage"))
date1=date()
content=server.htmlencode(request.form("content"))
insertsql="insert into reg(name,password,sex,email,address,time1,touxiang,homepage,content,oicq) values('"&name&"','"&pass&"',"&sex&",'"&email&"','"&address&"',#"&date1&"#,"&tou&",'"&homepage&"','"&content&"','"&qq&"')"

错误总说是insert into 语法错误，不知为何，搞了很久
谢谢大家，我按你们说的改了 ，可还是不行啊，头大死了，能再帮帮我么？

Answer 1

<%
set rs=db.execute(sql)
if not rs.eof or not rs.bof then
response.write "您的用户名已经被注册 <a href=reg.asp>重新注册</a>"
response.end
else
pass=trim(request.form("password"))
sex=trim(request.form("sex"))
email=trim(request.form("email"))
qq=trim(request.form("qq"))
address=trim(request.form("address"))
tou=trim(request.form("tou"))
homepage=trim(request.form("homepage"))
date1=date()
content=server.htmlencode(request.form("content"))
insertsql="insert into reg(name,password,sex,email,address,time1,touxiang,homepage,content,oicq) values('"&name&"','"&pass&"',"&sex&",'"&email&"','"&address&"',#"&date1&"#,"&tou&",'"&homepage&"','"&content&"','"&qq&"')"
end if
%>
1、在insert语句中name这个变量你没有定义.也没有接值.
2、touxiang这个字段是文本型 要将"&tou&"改成'"&tou&"'
祝你早日解决问题，更细心一些.

Answer 2

insert into reg(name,password,sex,email,address,time1,touxiang,homepage,content,oicq) values('"&name&"','"&pass&"',"&sex&",'"&email&"','"&address&"',#"&date1&"#,'"&tou&"','"&homepage&"','"&content&"','"&qq&"')

tou 变量 两边少了 ‘’

要是还不行 就把 日期也用 ‘# #’括起来

Answer 3

你有没有建REG表啊？