Question

asp问题，请进来看看

<!--#include file="conn.asp" -->
<%
username=request("username")
psd=request("psd")
sex=request("sex")
age=request("age")
qq=request("qq")
email=request("email")
adr=request("adr")
%>
<%
sql="select * from [user] where username="&username
'sql="select * from user where user='"&user&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof then
rs.addnew
rs("username")=username
rs("psd")=psd
rs("sex")=sex
rs("age")=age
rs("qq")=qq
rs("email")=email
rs("adr")=adr
rs.update
response.Write("<script language=javascript>")
response.Write("alert('注册成功，请登陆！');")
response.Write("window.location('index.asp');")
response.Write("</script>")
else
response.Write("<script language=javascript>")
response.Write("alert('该用户名已经被注册！');")
response.Write("window.history.go(-1);")
response.Write("</script>")
end if
%>

Microsoft JET Database Engine 错误 '80040e07'

标准表达式中数据类型不匹配。

15行：rs.open sql,conn,3,3
/study/action.asp，行15

Answer 1

sql="select * from [user] where username="&username
改成
sql="select * from [user] where username='"&username&"'"

Answer 2

在15行前面增加一句：

response.Write (sql)

然后看输出的SQL语句是否正确，不然很难判断的。