验证重复注册的问题

[havy505]

username=trim(request("username"))
if username<>"" then
sql="select * from rsadmin where username="&username
'Response.Write sql
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if not rs.eof then
Response.Write ("<script>alert('管理员名已存在！');javascript:history.back(0)</script>")
else
conn.execute("insert into rsadmin([username],[password])values('"&username&"','"&password&"')")
conn.close
Response.Write ("<script>alert('管理员已添加！');window.location='admin_user.asp'</script>")
end if
response.end
end if

结果每次都是执行Response.Write ("<script>alert('管理员名已存在！');javascript:history.back(0)</script>")这段代码，本人是菜鸟，困惑中

[KimSoft]

这一句好象有问题吧
sql="select * from rsadmin where username="&username

改成

sql="select * from rsadmin where [username]='" & username & "'"

[havy505]

又是这位朋友，问题已解决