table_a传入table_b的全在第一条，为什么？

germ007 2010-02-28 12:54:07

各位高手，不知这段问题出在什么地方。



table_a

<%'连接数据库

set rs=server.CreateObject("adodb.recordset")

rs.open "select * from office_meeting",conn,1,1

%>

    <td><form name="form1" method="post" action="table_b.asp?id=<%=int(rs("id"))%>">

      <table width="700" border="1" bgcolor="#CCCCCC">

        <tr>

          <td width="70" height="32"><div align="center" class="style2">项目名称</div></td>

          <td width="77"><div align="center" class="style2">是否完成</div></td>

          <td width="210"><div align="center" class="style2">状态说明</div></td>

          <td width="52"><div align="center" class="style2">更新</div></td>

        </tr>

        <%do while not rs.EOF%>

	<tr <%if int(rs("item_state"))="1"then%>bgcolor="#00ffff"<%end if%>>

          <td height="47"><div align="center"><span class="style2"><%response.write(rs("id"))%><%response.write(rs("item_name"))%></span></div></td>

          <td height="47"><div align="center"><span class="style2"><input type="checkbox" name="checkbox" value="1"<%if int(rs("item_state"))=1 then%>checked<%end if%>></span></div></td>

          <td height="47"><div align="center"><span class="style2"><input name="item_inf" type="text" id="item_inf" value="<%response.write(trim(rs("item_inf")))%>" size="30"></span></div></td>

          <td><input type="submit" name="Submit" value="更新" action="table_b.asp?id=<%=int(rs("id"))%>"></td>

        <%rs.MoveNext

          loop

         %>

	</tr>

      </table>

    </form>



table_b

<%

id=request.QueryString("id")

set rs2=server.CreateObject("adodb.recordset")

rs2.open "select * from office_meeting where id="&id,conn,1,3

rs2("item_inf")=trim(request("item_inf"))

rs2("item_state")=int(request("item_state"))

rs2.Update

rs2.Close

set rs2=nothing%>



表office_meeting

id  item_inf  item_state

1    start     1

2    close     0

3    runing    1