asp编程问题--为什么注册会员时总是说帐号重复

来源：百度知道编辑：UC知道时间：2024/05/22 20:34:01

<%
function changechr(str)
changechr=replace(replace(replace(replace(str,"<","<"),">",">"),chr(13),"<br>")," "," ")
changechr=replace(changechr,"'","‘")
changechr=replace(changechr,mid(" "" ",2,1),""")
end function

function GenID()
fname = now()
fname = replace(fname,"-","")
fname = replace(fname," ","")
fname = replace(fname,":","")
fname = replace(fname,"PM","")
fname = replace(fname,"AM","")
fname = replace(fname,"上午","")
fname = replace(fname,"下午","")
GenID = fname
end function <

set us = conn.execute("select username from uesr ")
//上面的uesr应该写错了,应该是user吧?另外还缺少查询条件
if not us.eof then
call msg("账号有重复！请返回！","-1")
end if
us.close
set us = nothing

上面的代码写错了,应修改如下:

set us = conn.execute("select username from user where username='"&username&"'")
if not us.eof then
call msg("账号有重复！请返回！","-1")
end if
us.close
set us = nothing

set us = conn.execute("select username from uesr ")
set us = conn.execute("select username from uesr where username='"&username&"'")

set us = conn.execute("select count（*） from user where username='"&username&"'")
需要加条件啊。你把整个数据库的都去了

ASP用户注册编程问题 asp编程问题--为什么注册会员时总是说帐号重复 asp问题，为什么我注册不了帐号|？ ASP编程问题 ASP网站编程问题！ asp编程问题询问ASP编程问题 asp编程,登陆问题请教编程问题ASP 请教ASP编程问题