rs.update 出什么问题了?
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dat/tj.mdb")
%>
<%
exec="select * from hhhm"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<%rs.movefirst%>
<form name="FrontPage_Form1" method="post" action="m1.asp" onsubmit="return FrontPage_Form1_Validator(this)">
<%
do while not rs.eof%>
<width="67%" height="30"><font color="red"><%=rs("hm")%></font>
<p>
<input type="text" name="t121" size="20" value="<%=rs("hh")%>">
<%
rs.movenext
loop
%>
<p align="center"><input type="submit" value="提交" name="B1"><input type="reset" value="全部重写" name="B2"></p>
</form>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("dat/tj.mdb")
exec="select * from hhhm"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,3%>
<%rs.movefirst%>
<%
do while not rs.eof%>
<%rs("hh")=request.form("hh")
rs.update
%>
<%
rs.movenext
loop
%>
<% rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
技术信息(用于支持人员)
- 错误类型: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] 由于其 Required 属性设置为真(True),字段 'hhhm.hh' 不能包含 Null 值。在此字段中输入一个数值。 /m1.asp, 第 13 行 rs.update 出什么问题了?