asp删除语句

mengyuhuapia 发布于 2009-08-27 09:28， 472 次点击

这段删除语句对吗？Conn,2,3,1这几个数字什么意思呀？
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = Conn
Rs.Open "SELECT * FROM links Order BY id"

if Request.QueryString("no")="yes" then
id= Trim(Request("id"))
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = Conn
Rs.Open "DELETE FROM links Where id="&id,Conn,2,3,1

1 回复

yms1232009-08-27 13:38

if Request.QueryString("no")="yes" then
id= Trim(Request("id"))
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = Conn
Rs.Open "DELETE FROM links Where id="&id,Conn,2,3,1
删除语句不能这样执行
if Request.QueryString("no")="yes" then
id= Trim(Request("id"))
Conn.execute("DELETE FROM links Where id="&id)
这样直接执行。