mysql="select * from Bbs_User where User_Name="& request.form("Name")
看你是什么数据库了
改为这个试试
mysql="select * from Bbs_User where User_Name='"& request.form("Name")&"'"
看你是什么数据库了
改为这个试试
mysql="select * from Bbs_User where User_Name='"& request.form("Name")&"'"
rs.open mysql,conn,3,2 还是在这一句报错
mysql="select * from Bbs_User where User_Name like '%"&request.form("Name")&"%'"
试试把
mysql="select * from Bbs_User where User_Name like '"
&trim(request.form("Name"))
&"'"
mysql="select * from Bbs_User where User_Name="& request.form("Name")
如果是字符型用:
r_name=request.form("name")
mysql="select * from Bbs_User where User_Name='"&r_name&"'
Response.write request.form("Name")
若有值试试这句:
mysql="select * from Bbs_User where User_Name='"& CStr(request.form("Name")) &"'"
<%
set conn=server.createobject("ADODB.connection")
conn.open"DSN=SQL One;uid=sa;pwd=;database=BBS"
set rs=server.Createobject("ADODB.Recordset")
mysql="select * from Bbs_User where User_Name like '"&trim(request.form("Name"))&"'"
rs.open mysql,conn,3,2
if request.form("Name")<>"" and request.form("Sex")<>"" _
and request.form("Age")<>"" and request.form("Power")<>"" _
and rs.eof then
rs.open "Bbs_User",conn,3,2
rs.addnew
rs("User_Name")=request.form("Name")
rs("User_Sex")=request.form("Sex")
rs("User_Age")=request.form("Age")
rs("User_Power")=request.form("Power")
rs.UpDate
end if
%>