|
#2
yms1232010-12-15 11:03
|
只有本站会员才能查看附件，请 登录
同时选择两项或以上，点击删除后就出现以下错误：
==================================================
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (逗号) 在查询表达式 'id_ku=15, 14' 中。
/3/system/ku_del.asp，行 10
======================================================
代码如下：
程序代码：<%if session("redboy_username")="" then%>
<script language="javascript">top.location.href="../index.asp"</script>
<%
response.end
end if
%>
<!-- #include file="../conn2.asp" -->
<%
sql="select * from produit where id_ku="&request("id")&""
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("此仓库中还存有产品，不能删除！")
window.history.go(-1)
</script>
<%
response.end
end if
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("delete from produit where id_ku="&id(i))
sql="delete from ku where id="&id(i)
conn.execute(sql)
next
response.redirect "ku.asp"
%>
<script language="javascript">top.location.href="../index.asp"</script>
<%
response.end
end if
%>
<!-- #include file="../conn2.asp" -->
<%
sql="select * from produit where id_ku="&request("id")&""
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("此仓库中还存有产品，不能删除！")
window.history.go(-1)
</script>
<%
response.end
end if
id=replace(request("id")," ","")
id=split(id,",")
for i=0 to UBound(id)
conn.execute("delete from produit where id_ku="&id(i))
sql="delete from ku where id="&id(i)
conn.execute(sql)
next
response.redirect "ku.asp"
%>
[ 本帖最后由 天蝎风 于 2010-12-15 10:45 编辑 ]