asp command語句裡的兩個sql
[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 這個就不行了! if>
'刪除回復貼
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 這個就不行了! if>
睡前话,域名
中国强大的真正希望---浙江大学郑强演讲
