一小段ASP代码,各位老师给看一下.

来源:百度知道 编辑:UC知道 时间:2024/05/22 16:37:43
if request("cur_action")="checklogin" then
set rs=conn.execute("select * from tRegMember where LoginID='"&request("T_LoginID")&"' and PassWord='"&request("T_PassWord")&"'")
If rs.eof or rs.bof then
response.write "<script> alert('错误的会员帐号、密码或帐号未通过,如有问题请与我们联系!');history.back();</script>"
response.end
End If

我想让某条记录如"T_PassWord2"字段里面的数值等于1时,出提示"未通过审核",加在上面那段的下面,应该怎么加,请位老师给指点一下.谢谢啦.
试用了下面两位老师的代码,都不行呢,俺真是菜鸟,大家都说到这份上了,这么清楚我还是弄不上.能不能贴个全的.
--------------------------------------------------
还是提示错误,"该页无法显示!"

========================================================
---------------------------------------------------------

if request("cur_action")="checklogin" then
set rs=conn.execute("select * from tRegMember where LoginID='"&request("T_LoginID")&"' and PassWord='"&request("T_PassWord")&"'")
If rs.eof and rs.bof then
response.write "<script> alert('错误的会员帐号、密码,如有问题请与我们联系!');history.back();</script>"
response.end
elseif rs("T_PassWord2")="1" then
ponse.write "<script> alert('未通过审核!');history.back();</script>"
response.end
End If

if request("cur_action")="checklogin" then
set rs=conn.execute("select * from tRegMember where LoginID='"&request("T_LoginID")&"' and PassWord='"&request("T_PassWord")&"'")
If rs.eof or rs.bof then
if rs("T_PassWord2")="1" then
Response