28,409
社区成员




<%
If Request.QueryString("action")="save" Then
Set ids = Request.Form("id")
Set des = Request.Form("des")
For i = 1 To ids.Count
conn.Execute "Update tab Set des=" & des(i) & " WHERE id=" & ids(i)
Next
End If
%>
<form action="?action=save" method="post">
<%
Set rs = conn.Execute("SElECT id, des FROM tab WHERE ....")
While Not rs.EOF
%> <input type="text" value="<%=rs("id")%>" name="id" />
<select name="des">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select><br />
<%
rs.MoveNext
Wend
%>
</form>
update set 新字段=新值 where id=要更改的ID或其它条件