asp command語句裡的兩個sql 不指定

Else , 2008/04/09 10:09 , 代码片段,演示也有 , Comments(0) , Reads(5219) , Via Original
[codes=vb]
'刪除回復貼
If (Request.querystring("del")="ok") Then
  '刪除權限,用來觸發ajax的error
  if session("bbsadmin")=1 then
    dim delrs
    Set MM_delCmd = Server.CreateObject ("ADODB.Command")
    MM_delCmd.ActiveConnection = MM_conn_STRING
  
    SelectSQL = "Select * from bbs WHERE id ="&Request.form("id")
    MM_delCmd.CommandText =SelectSQL
    MM_delCmd.Prepared = true
    set delrs = MM_delCmd.Execute
    if delrs.Fields.Item("cc").Value<>"" then
      DeleteFile(server.MapPath("../obj/"&delrs.Fields.Item("cc").Value))
    end if
    MM_delCmd.CommandText = "DELETE FROM bbs WHERE id ="&Request.form("id")&""
    MM_delCmd.Prepared = true
    MM_delCmd.Execute
    MM_delCmd.ActiveConnection.Close
    response.Write("刪除成功")
    response.End()
  end if
End If  
[/codes]這個是刪除的,我試了一個insert into 和一個update set 這個就不行了!
Tags: ,
Add a comment

Nickname

Site URI

Email

Enable HTML Enable UBB Enable Emots Hidden Remember [Login] [Register]