注册 登录
编程论坛 ASP技术论坛

ASP编程求助!!!关于删除记录的问题

麻子 发布于 2008-04-17 16:06, 539 次点击
原代码很长,这里截取一段,用于控制记录的删除,但运行后不管怎么样,总是提示“命令错误”,不知道是不是循环上出了问题,请高手指教,不胜感激!
代码如下:
    If Request("ifok") = "del" Then     '474
        lists = Request.Form("list")     '476
        tmeplist = Split(lists, ",")    '477
        If lists = "" Then   '478
            call superdll.msg("请选择您要删除的信息!", "-1",1)     '480
        End If   '481
        For i = 0 To UBound(tmeplist)    '482
        superdll.pages(tmeplist(i))
            Set rs = Server.CreateObject("ADODB.recordset")
   rs.open"select * from sc where id="&tmeplist(i)&" and sendid="&userid ,conn,1,1
IF  rs.BOF=true and rs.EOF =true THEN
superdll.msg "请求错误","-1",1
else     
            conn.Execute ("delete from sc where id=" & tmeplist(i) &" and sendid="&userid)     '483\
            end if
        Next
        rs.close
        set rs=nothing  '487  '484
        Response.Redirect ""&superdll.showurl("sc1.asp")&""
    End If  
    
    
    sc= temp_skins
0 回复
1