<%
if request.QueryString("downorup")<>"" then
set rs1=server.CreateObject("adodb.recordset")
sql1="select id,sxh from channel where id="&request.QueryString("id")
rs1.open sql1,conn,1,3
if not rs1.eof then
if request.QueryString("downorup")="up" then
rs1("sxh")=rs1("sxh")-1
rs1.update
end if
if request.QueryString("downorup")="down" then
rs1("sxh")=rs1("sxh")+1
rs1.update
end if
rs1.close
set rs1=nothing
set rs2=server.CreateObject("adodb.recordset")
if request.QueryString("downorup")="up" then
sql2="select id,sxh from channel where id="&request.QueryString("id")-1
end if
if request.QueryString("downorup")="down" then
sql2="select id,sxh from channel where id="&request.QueryString("id")+1
end if
rs2.open sql2,conn,1,3
if request.QueryString("downorup")="up" then
rs2("sxh")=rs2("sxh")+1
rs2.update
end if
if request.QueryString("downorup")="down" then
rs2("sxh")=rs2("sxh")-1
rs2.update
end if
call msg("1","更改成功","admin_pdlist.asp","")
rs2.close
set rs2=nothing
end if
end if
%>
mm 选定值为rs("id")
if request("mm")<>"" then
a=request("mm")
aryid=split(a,",")
set rs=server.CreateObject("adodb.recordset")
for i=0 to ubound(aryid)
sql="update board set xu="&a&"where id="&aryid(i)
rs.open sql,conn,3,2
next
end if
For Each Element In request.Form
For i=1 To request.Form(element).count
If InStr(element,"trs")<>0 then
theid=Trim(Mid(element,6,3))
result=request.Form(element)(i)
sql="update webroom set R_RS='"&result&"' where R_ID="&theid
response.wirte sql
response.end
accon.execute(sql)
End If
Next
Next
================
我是这样做的.但是不行