判断用户名是否存在,大家帮我看下,问题出在哪里啊?
pzlk 2003-10-21 11:13:40 if way="tianjia" then
username=request("username2")
userpwd=request("userpwd2")
bbi_name=request("bbi_name2")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from b_user where username='"&username&"'",conn,1,1
if not rs.bof and rs.eof then
response.write "<p align=center><font color=red>错误,该用户名已经被使用,请重新选择用户名!</font></p>"
rs.close
response.redirect "user.asp?bbi_name="&bbi_name
else
rs.close
sql = " insert into b_user (username,userpwd,bbi_name) values ('"&username&"','"&userpwd&"','"&bbi_name&"')"
conn.Execute(sql)
response.redirect "user.asp?bbi_name="&bbi_name
end if
end if