UC知道Asp:记录修改不了,请帮忙修改
来源：百度知道 编辑：UC知道 时间：2024/06/23 13:38:40
文件"edit.asp"
<form name="form1" method="post" action="edit1.asp">
<input name="student_num " type="text" >
<input type="submit" value="确定"><input type="reset" value="重置">
</form>
文件"edit1.asp"
<!--#include file="conn.asp"-->
<!--#include file="err.asp"--><head>
<meta content="text/html; charset=GB2312">
</head>
<%
exec="select * from students where student_num='"&request.form("student_num")&"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open exec,conn
%>
<form name="form1" method="post" action="edit2.asp">
Student_id:
<input name="student_id" type="text" value=
<form name="form1" method="post" action="edit1.asp">
<input name="student_num " type="text" >
<input type="submit" value="确定"><input type="reset" value="重置">
</form>
文件"edit1.asp"
<!--#include file="conn.asp"-->
<!--#include file="err.asp"--><head>
<meta content="text/html; charset=GB2312">
</head>
<%
exec="select * from students where student_num='"&request.form("student_num")&"'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open exec,conn
%>
<form name="form1" method="post" action="edit2.asp">
Student_id:
<input name="student_id" type="text" value=
if student_num<>"" then '这里是否始终是空的呢？student_num是否被赋值呢
'试下这样：
if not rs.eof then
rs("student_id")=request.form("student_id")
rs("student_num")=request.form("student_num")
rs("name")=request.form("name")
rs("sex")=request.form("sex")
rs("age")=request.form("age")
rs("department")=request.form("department")
rs("class")=request.form("class")
rs("address")=request.form("address")
rs("phone_num")=request.form("phone_num")
rs.update
end if
数据库在，NTFS分区。没有对everyone赋予权限。
或者
rs.open exec,conn,3,3
s.open exec,conn,1,3
改为:
rs.open exec,conn,3,2
在 if student_num<>"" then
rs("student_id")=request.form("student_id")