用数组,成批修改数据,(不错)

王朝other·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

<%

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

%>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航