ASP高手帮我看看~~~~

来源:百度知道 编辑:UC知道 时间:2024/05/12 13:06:54
这是我写的一段注册程序,我运行后就是不能实现注册老是说用户名以存在实际上我数据库里只有一个我预先弄进去的用户名.....高手帮我看看以下是代码:
<%
if request.QueryString("action")="save" then
dim ID,PWS,conpws,email,name,sex,rs,sql
ID=trim(request.Form("ID"))
PWS=trim(request.Form("PWS"))
conpws=trim(request.Form("conpws"))
email=trim(request.Form("email"))
name=trim(request.Form("name"))
sex=request.Form("sex")
if ID="" or PWS="" or conpws="" or email="" or name="" or sex="" then
response.Write ("<font color=red>请确认所填信息的正确性!</font><br>")
Response.Write ("<br><br><a href='javascript:history.back();'><font color=red>返回</font></a>")
response.End()
end if
set rs=Server.CreateObject("ADODB.Recordset")
sql="select

改为:

<%
if request.QueryString("action")="save" then
dim ID,PWS,conpws,email,name,sex,rs,sql
ID=trim(request.Form("ID"))
PWS=trim(request.Form("PWS"))
conpws=trim(request.Form("conpws"))
email=trim(request.Form("email"))
name=trim(request.Form("name"))
sex=request.Form("sex")
if ID="" or PWS="" or conpws="" or email="" or name="" or sex="" then
response.Write ("<font color=red>请确认所填信息的正确性!</font><br>")
Response.Write ("<br><br><a href='javascript:history.back();'><font color=red>返回</font></a>")
response.End()
end if
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from members where ID='"&ID&"'"
rs.open sql,Co