房屋装修验收表:asp问题,请进来看看
来源:百度文库 编辑:神马品牌网 时间:2024/05/06 11:06:46
<!--#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
<%
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
sql="select * from [user] where username="&username
改成
sql="select * from [user] where username='"&username&"'"
在15行前面增加一句:
response.Write (sql)
然后看输出的SQL语句是否正确,不然很难判断的。