标题:asp删除语句
只看楼主
mengyuhuapia
Rank: 1
等 级:新手上路
帖 子:14
专家分:0
注 册:2009-8-5
结帖率:100%
已结贴  问题点数:30 回复次数:1 
asp删除语句
这段删除语句对吗?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
搜索更多相关主题的帖子: asp 
2009-08-27 09:28
yms123
Rank: 16Rank: 16Rank: 16Rank: 16
等 级:版主
威 望:209
帖 子:12488
专家分:19042
注 册:2004-7-17
得分:30 
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)
这样直接执行。
2009-08-27 13:38



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-283810-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 2.086001 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved