Eliminare file

[Rossella_75]

ciao a tutti,

riesco ad eliminare un record dal database ma non sò come eliminare un file dal server mi aiutate ad inserire l'eliminazione del file dal server?

questo è il file che vorrei eliminare

<%=(elimina.Fields.Item("ICONA").Value)%>

per eliminare il record faccio cosi

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Delete Record: declare variables

if (CStr(Request("MM_delete")) = "form1" And CStr(Request("MM_recordId")) <> "") Then

  MM_editConnection = MM_connessione_STRING
  MM_editTable = "ARTICOLI"
  MM_editColumn = "ID"
  MM_recordId = "" + Request.Form("MM_recordId") + ""
  MM_editRedirectUrl = "success.asp?success=ARTICOLO ELIMINATO!"

  ' append the query string to the redirect URL
  If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then
    If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
      MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
    Else
      MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
    End If
  End If
  
End If
%>
<%
' *** Delete Record: construct a sql delete statement and execute it

If (CStr(Request("MM_delete")) <> "" And CStr(Request("MM_recordId")) <> "") Then

  ' create the sql delete statement
  MM_editQuery = "delete from " & MM_editTable & " where " & MM_editColumn & " = " & MM_recordId

  If (Not MM_abortEdit) Then
    ' execute the delete
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    If (MM_editRedirectUrl <> "") Then
      Response.Redirect(MM_editRedirectUrl)
    End If
  End If

End If
%>
<%
Dim elimina__MMColParam
elimina__MMColParam = "1"
If (Request.QueryString("ID") <> "") Then 
  elimina__MMColParam = Request.QueryString("ID")
End If
%>
<%
Dim elimina
Dim elimina_numRows

Set elimina = Server.CreateObject("ADODB.Recordset")
elimina.ActiveConnection = MM_connessione_STRING
elimina.Source = "SELECT * FROM ARTICOLI WHERE ID = " + Replace(elimina__MMColParam, "'", "''") + ""
elimina.CursorType = 0
elimina.CursorLocation = 2
elimina.LockType = 1
elimina.Open()

elimina_numRows = 0
%>

adesso dovedevo inserire il codice per eliminare il file?

Grazie mille

[Roby_72]

http://www.w3schools.com/asp/met_deletefile.asp

Roby

[Rossella_75]

si ho gia letto, e ho fatto anche una ricerca sul forum, solo che cmq faccio non riesco!!

non sò dove applicarlo

mi faresti vedere come

[Roby_72]

Alla fine di quello che hai postato prima.

Roby

[Rossella_75]

cosi??

<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
  MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Delete Record: declare variables

if (CStr(Request("MM_delete")) = "form1" And CStr(Request("MM_recordId")) <> "") Then

  MM_editConnection = MM_connessione_STRING
  MM_editTable = "ARTICOLI"
  MM_editColumn = "ID"
  MM_recordId = "" + Request.Form("MM_recordId") + ""
  MM_editRedirectUrl = "success.asp?success=ARTICOLO ELIMINATO!"

  ' append the query string to the redirect URL
  If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then
    If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
      MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
    Else
      MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
    End If
  End If
  
End If
%>
<%
' *** Delete Record: construct a sql delete statement and execute it

If (CStr(Request("MM_delete")) <> "" And CStr(Request("MM_recordId")) <> "") Then

  ' create the sql delete statement
  MM_editQuery = "delete from " & MM_editTable & " where " & MM_editColumn & " = " & MM_recordId

  If (Not MM_abortEdit) Then
    ' execute the delete
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    If (MM_editRedirectUrl <> "") Then
      Response.Redirect(MM_editRedirectUrl)
    End If
  End If

End If
%>
<%
Dim elimina__MMColParam
elimina__MMColParam = "1"
If (Request.QueryString("ID") <> "") Then 
  elimina__MMColParam = Request.QueryString("ID")
End If
%>
<%
Dim elimina
Dim elimina_numRows

Set elimina = Server.CreateObject("ADODB.Recordset")
elimina.ActiveConnection = MM_connessione_STRING
elimina.Source = "SELECT * FROM ARTICOLI WHERE ID = " + Replace(elimina__MMColParam, "'", "''") + ""
elimina.CursorType = 0
elimina.CursorLocation = 2
elimina.LockType = 1
elimina.Open()

elimina_numRows = 0

dim fs
Set fs=Server.CreateObject("Scripting.FileSystemObject") 
fs.ImageFile("../images/"elimina.Fields.Item("ICONA").Value".jpg",True)
if fs.FileExists("../images/"elimina.Fields.Item("ICONA").Value".jpg") then
  fs.DeleteFile("../images/"elimina.Fields.Item("ICONA").Value".jpg")
end if
set fs=nothing

%>

:master:

[Roby_72]

Devi usare il server.MapPath per definire il percorso...

Roby

[Rossella_75]

cosi?

fs.ImageFile Server.MapPath("/images/"elimina.Fields.Item("ICONA").Value".jpg",True)

[Roby_72]

Le concatenazioni....

fs.ImageFile Server.MapPath("/images/"& elimina.Fields.Item("ICONA").Value &".jpg",True)

Roby

[Rossella_75]

ok

diventa cosi giusto?

dim fs
Set fs=Server.CreateObject("Scripting.FileSystemObject") 
fs.ImageFile Server.MapPath("/images/"& elimina.Fields.Item("ICONA").Value &".jpg",True)
if fs.FileExists Server.MapPath("/images/"& elimina.Fields.Item("ICONA").Value &".jpg") then
  fs.DeleteFile Server.MapPath("/images/"& elimina.Fields.Item("ICONA").Value &".jpg")
end if
set fs=nothing

[Roby_72]

Hai provato?

Roby