string newid = Request["newsid"]; string sql = "delete news where id=" + newid;执行这个SQL就可以达到楼主的目的了
test.asp <!--#include file="conn.asp"--> <% set rs=server.createobject("adodb.recordset") sqlstr="delete news where id="&request.querystring("newsid") rs.open sqlstr,conn,1,3 %> 地址传递参数 http://*****/test.asp?newsid=* ---------------------------------------------------- 这样不行吗?
newid = Request("newsid"); if newid = "*" then qlstr="delete news where id is not null end if
<% set rs=server.createobject("adodb.recordset") sqlstr="delete news where id="&request.querystring("newsid") conn.exec(sqlstr) %>
string newid = Request("newsid"); string sql = "delete news where id="&newid;
本来就是asp设当id传值为-1时删除所有. Dim id:id=Request("id") If Not IsNumeric(id) Then id=0strSql = "DELETE FROM tb WHERE id=ISNULL(NULLIF(" & id & ",-1),id)" conn.Execute(strSql)语句功能上相当于执行:DECLARE @id INT SET @id=... DELETE FROM tb WHERE id=ISNULL(NULLIF(@id,-1),id)也即DELETE FROM tb WHERE id= CASE WHEN @id=-1 THEN id ELSE @id END即,当id=-1时删除所有,为其它值时,删除匹配的记录
string sql = "delete news where id=" + newid;执行这个SQL就可以达到楼主的目的了
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sqlstr="delete news where id="&request.querystring("newsid")
rs.open sqlstr,conn,1,3
%>
地址传递参数 http://*****/test.asp?newsid=*
----------------------------------------------------
这样不行吗?
if newid = "*" then
qlstr="delete news where id is not null
end if
set rs=server.createobject("adodb.recordset")
sqlstr="delete news where id="&request.querystring("newsid")
conn.exec(sqlstr)
%>
string sql = "delete news where id="&newid;
Dim id:id=Request("id")
If Not IsNumeric(id) Then id=0strSql = "DELETE FROM tb WHERE id=ISNULL(NULLIF(" & id & ",-1),id)"
conn.Execute(strSql)语句功能上相当于执行:DECLARE @id INT
SET @id=...
DELETE FROM tb WHERE id=ISNULL(NULLIF(@id,-1),id)也即DELETE FROM tb WHERE id= CASE WHEN @id=-1 THEN id ELSE @id END即,当id=-1时删除所有,为其它值时,删除匹配的记录
request接值后删除.