<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("db\user_db.mdb")
Conn.Open connstr
%>
<%
textfield=request("textfield")
textfield3=request("textfield3")
if textfield="" then
response.write("<script>alert('用户名不能为空')</script>")
response.write"<script>document.location.href='conn4.asp'</script>"
response.end
elseif textfield3=""then
response.write("<script>alert('密码不能为空)</script>")
response.write"<script>document.location.href='conn4.asp'</script>"
response.end
end if
sql="select*from user where textfield='"&db_textfield&"'and textfield3='"&db_textfield3&"'"
set rs=conn.execute(sql)
if not rs.eof then
response.write("<script>alert('登陆成功！！')</script>")
response.write"<script>document.location.href='conn6.asp'</script>"
else
response.write("<script>alert('登陆失败！！请检查用户名和密码是否正确')</script>")
response.write"<script>document.location.href='conn4.asp'</script>"
end if
set rs = nothing
%>
就是这段代码是什么地方有问题呢?为什么成功登陆跳转后就有错误提示:
Microsoft JET Database Engine 错误 '80040e14'
FROM 子句语法错误。
/Connections/conn5.asp，行 19
请高手帮忙看看是哪有问题了,急急.......谢谢啊