Delete where id in
来源:百度知道 编辑:UC知道 时间:2024/09/23 11:32:40
<form>
<input name="id" type="checkbox" value="1">
<input name="id" type="checkbox" value="2">
</form>
<%
dim sid,i
sid=""
for i=1 to request.form("id").count
sid=sid&"|"&request.form("id")(i)
next
sid=split(sid,"|")
for i=0 to ubound(sid)
tid=sid(i)
next
sql="delete from link where id in ("&tid&")"
Conn.execute(sql)
%
为什么这样只能删除一条记录呢? 该如何修改啊??
移动NEXT之后就会出错,
语法错误 (操作符丢失) 在查询表达式 'id in ()' 中。
<input name="id" type="checkbox" value="1">
<input name="id" type="checkbox" value="2">
</form>
<%
dim sid,i
sid=""
for i=1 to request.form("id").count
sid=sid&"|"&request.form("id")(i)
next
sid=split(sid,"|")
for i=0 to ubound(sid)
tid=sid(i)
next
sql="delete from link where id in ("&tid&")"
Conn.execute(sql)
%
为什么这样只能删除一条记录呢? 该如何修改啊??
移动NEXT之后就会出错,
语法错误 (操作符丢失) 在查询表达式 'id in ()' 中。
<form>
<input name="id" type="checkbox" value="1">
<input name="id" type="checkbox" value="2">
</form>
<%
dim sid,i
sid=""
for i=1 to request.form("id").count
sid=sid&"|"&request.form("id")(i)
next
sid=split(sid,"|")
for i=0 to ubound(sid)
tid=sid(i)
sql="delete from link where id in ("&tid&")"
Conn.execute(sql)
next
%>
补充回答:
你先输出tid看看里面是什么内容
把倒数4 的next往下移,到%前面那行
你的错误在这里("&tid&")"这是链接符错误 改成(".&tid&.")"试试
Delete where id in
sqldel="delete from book where id="&request("id")
exec="delete * from guestbook where id="&request.form("id")"
rs.open "delete * from NEWS where id="&request("id"),conn,1
sybase 数据库操作 delete from where 如果delete form不加表名会出现什么后果
select * from table1 where id in (select id from table2),
利用rs.delete删除对应id记录的问题
SqlStmt = "DELETE FROM Customer WHERE CustId='" + Trim(TmpId) + "'"
conn.execute("delete * from SMT_sca where SMT_key1=0 and SMT_enrol=3")
sql="select * from main where id="&id 这句啥意思