insert into 语句错误??急,可追加分数!

来源:百度知道 编辑:UC知道 时间:2024/09/23 23:22:49
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(&

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 变量 两边少了 ‘’

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

<%
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()