谢谢大家,我把源代码帖出来,问题是:不会报错,但是表当中的数据提交不到数据库中,为什么?麻烦大家了!
<%
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
%>
mysql="select * from Bbs_User where User_Name="& request.form("Name")
看你是什么数据库了
改为这个试试
mysql="select * from Bbs_User where User_Name='"& request.form("Name")&"'"
这个要看你的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&"'