|
|
用数组,成批修改数据,(不错) |
|
|
作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站 |
<% set rs=server.createobject("adodb.recordset") sql="select * from foreign" rs.open sql,conn,1,1 %> <form method="POST" name="form1" action="price_ok.asp?action=update"> <% do while not rs.eof%> <input type="hidden" name="id" value="<%=rs("id")%>"> <input name="name" type="text" id="name" value="<%=rs("name")%>" size="17"> <input name="inpr" type="text" id="inpr" value="<%=rs("inpr")%>" size="17"> <input name="outpr" type="text" id="outpr" value="<%=rs("outpr")%>" size="17"> <% rs.movenext loop%> <input type="submit" name="Submit" value="提交"> <input type="reset" name="reset" value="重置"> </form> ---------------------------------price_ok.asp--------- <% if request("action")="update" then for i=1 to request.form("id").count id=replace(request.form("id")(i),"'","") name=replace(request.form("name")(i),"'","") inpr=replace(request.form("inpr")(i),"'","") outpr=replace(request.form("outpr")(i),"'","") 'response.write id&inpr&outpr&name 'response.write "<br>" conn.execute("update foreign set name='"&name&"',inpr="&inpr&",outpr="&outpr&" where id="&id) next conn.close set conn=nothing response.write "<script language=javascript>alert('字段设置成功!');window.location.href='price.asp';</script>" end if %>
|
|
相关文章:相关软件: |
|