UC知道急,asp查询更新记录问题?
来源：百度知道 编辑：UC知道 时间：2024/05/31 13:20:55
急,asp查询更新记录问题?
tab1中有三个字段id,name,content
index.asp:
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from tab1 order by id asc"
rs.open sql,cn,1,1
%>
<table border=1 width=300 align=center><tr><td align=center>
<form name="reg" action="2.asp" method="get">
<%
do while not rs.eof
%>
<%=rs("name")%>:
<%
response.write "<input type=checkbox name=usr value="&rs("id")&">"
%>
<%
rs.movenext
loop
%>
<br><br>content:
<textarea cols=40 rows=7 name="content"></textarea>
<input type=submit name="ok" value="确定">
<input type=reset name="reset" value="取消">
<
tab1中有三个字段id,name,content
index.asp:
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from tab1 order by id asc"
rs.open sql,cn,1,1
%>
<table border=1 width=300 align=center><tr><td align=center>
<form name="reg" action="2.asp" method="get">
<%
do while not rs.eof
%>
<%=rs("name")%>:
<%
response.write "<input type=checkbox name=usr value="&rs("id")&">"
%>
<%
rs.movenext
loop
%>
<br><br>content:
<textarea cols=40 rows=7 name="content"></textarea>
<input type=submit name="ok" value="确定">
<input type=reset name="reset" value="取消">
<
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
把2.asp的代码改成这样：
2.asp
<!--#include file="conn.asp"-->
<%
dim b,t,a,updateRs
b=request("usr")
t=replace(b," ","")
a=split(t,",")
'**** 说明以上三个变量只需要一个即可，比如： *******************
'**** a=request("usr") *****************************************
'**** a=replace(a," ","") **************************************
'**** a=split(a,",") *******************************************
updateRs="<p align=center>"
for i=0 to ubound(a)
set rs=server.createobject("adodb.recordset")
sql="select * from tab1 where id="&a(i)
rs.open sql,cn,3,3
rs("content")=request("content")
rs.update
updateRs=updateRs & rs("name")&":"&rs("content")&"<