请交 asp 的 一段删除代码?该怎么写

来源:百度知道 编辑:UC知道 时间:2024/05/31 11:57:44
<%
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
sql="delete from sell where id=" & id(i)
conn.execute(sql)
next
response.redirect "sell.asp?page="&request("page")&"&startdate="&nowstartdate&"&enddate="&nowenddate&"&keyword="&nowkeyword&"&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"&order8="&request("order8")&"&order9="&request("order9")&"&order10="&request("order10")&"&order11="&request("order11")&"&order12="&request("order12")&&

conn.execute("update huiyuan set price=price-1,jifen=jifen-1 where 判断条件")

给你个提示
通过ID打开相应数据库 然后对相关记录进行减分等操作
然后rs.Update()就可以了