reg_detectname.asp <!--#include file="conn.asp"--> <% if request("a")="b" then User=request("name")
set rs=server.createobject("adodb.recordset") rs.open "select * from UserMain where User='"&User&"'",conn,1,1 if rs.bof and rs.eof then response.write "<font color=green>可以注册 !</font>" else response.write "<font color=red>不可以注册 !</font>" end if rs.close set rs=nothing end if %>
reg_detectname.asp <!--#include file="../db_conn/dhconn.asp"--> <% if request("a")="b" then User=request("name")
set rs=server.createobject("adodb.recordset") rs.open "select * from zy where zy='"&User&"'",conn,1,1 if rs.bof and rs.eof then response.write "<font color=green>可以注册 !</font>" else response.write "<font color=red>不可以注册 !</font>" end if rs.close set rs=nothing end if %>
直接连接数据库之后显示几个问号,还是没有是否注册过 <% if request("a")="b" then User=request("name") Set OBJConn = Server.CreateObject("ADODB.Connection") OBJConn.Open "yx","sa","123456" sersql="select * from zy where zy='"&User&"'" Set rs=OBJConn.Execute (sersql) if rs.bof and rs.eof then response.write "<font color=green>可以注册 !</font>" else response.write "<font color=red>不可以注册 !</font>" end if rs.close set rs=nothing end if %>
reg_detectname.asp <!--#include file="../db_conn/dhconn.asp"--> <% Response.ContentType = "text/html;charset=GB2312" '加上这段代码 if request("a")="b" then User=request("name")
set rs=server.createobject("adodb.recordset") rs.open "select * from zy where zy='"&User&"'",conn,1,1 if rs.bof and rs.eof then response.write "<font color=green>可以注册 !</font>" else response.write "<font color=red>不可以注册 !</font>" end if rs.close set rs=nothing end if %>
会不会是你的数据库链接方式不对,我没用过sql server,下面的方式楼主可以做个参考 'SQL OleDB 连接 'Connstr = "Driver={SQL Server}; Server=("&SqlLocalName&"); User ID="&SqlUserName&"; Password="&SqlPassWord&"; database="&SqlDatabaseName&";" 'SQL 连接 On Error Resume Next Set Conn = Server.CreateObject("ADODB.CONNECTION") Conn.Open Connstr If Err.Number<>0 Then Err.Clear Set Conn = Nothing Response.Write("<b style='font-size:16px'>数据库连接出错,请检查连接字串!") Response.End() End If End Sub
Sub CloseDatabase If IsObject(Conn) then Conn.Close Set Conn = Nothing End if End Sub