有关批量更新的问题,急死我了
这是从数据取出的值,我想批量更新数据
取出页:
<form name="form1" method="post" action="save_stuinfo.asp">
<% do while not rs.eof%>
<td align=center><%=rs("stu_reg")%></td>
<input type="hidden" name="id" value="<%=rs("id")%>">
<input type="text" name="stu_homework<%=rs("id")%>" value="<%=rs("stu_homework")%>" >
....
<%
rs.movenext
loop
%>
处理页:
<!--#include file="inc/conn.asp"-->
<% arr=split(request("id"),",")
set rs=server.CreateObject("adodb.recordset")
for j=0 to ubound(arr)
rs.open "select * from students_info where id="&arr(j),conn,1,3
rs("stu_homework")=request.form("stu_homework"&arr(j))
....
rs.update
rs.close
next
%>,我测试了一遍,只能更新第一笔数据,怎么办啊,很急,谢谢您解答:)