用asp做删除页面,提示:标准表达式中数据类型不匹配。数据库里有四个字段:id,bt,ly-name,ly-text代码如下
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><%
dim lybh
lybh=request("checkbox")
arr=split(lybh,",")
set cnn=server.CreateObject("ADODB.Connection")
cnn.open "dsn=bysj"
for i=0 to ubound(arr)
sql="delete from lyb where id='"&trim(arr(i))&"'"
cnn.execute(sql)
next
%>
<script language="javascript">
alert("删除成功!");
location.href="del-ly.asp";
</script>
请问哪里错了?需要怎么修改?