Ciao, ci ho lavorato ed ho seguito la ricerca che mi hai consigliato.
Ho scritto un po' di codice, dai un'occhiata e dimmi se puo' funzionare:
codice:
<%
Sub PrelevaRecord(Record)
sSQL="Select cognome, nome, SourceFileName, ContentType, DataSize, Data from Upload where UploadID=" & Record
rs.Open sSQL, GetConnection,3,3
FolderName = Server.MapPath("/public") & "\" & LCase(rs("cognome")) & "-" & LCase(rs("nome"))
IF NOT FolderFind(FolderName) THEN
Set FS = CreateObject("scripting.filesystemobject")
Set TempFolder = FS.CreateFolder(FolderName)
Set FS = Nothing
END IF
sFileName = TempFolder & "\" & rs("SourceFileName")
dim oStr
set oStr=server.CreateObject("ADODB.Stream")
if ucase(Right(sFileName,3))="TXT" then
oStr.Type = 2 'text
else
oStr.Type = 1 'binary
end if
oStr.Open
oStr.Write rs.Fields("Data").Value
oStr.SaveToFile sFileName, 2 'salvo il file sul server
oStr.close
set oStr=Nothing
rs.Close
End sub
Sub SpedisciFile(Record)
sSQL="Select cognome, nome, SourceFileName, ContentType, DataSize, Data from Upload where UploadID=" & Record
rs.Open sSQL, GetConnection,3,3
FolderName = Server.MapPath("/public") & "\" & LCase(rs("cognome")) & "-" & LCase(rs("nome"))
sFileName = TempFolder & "\" & rs("SourceFileName")
set oStr=server.CreateObject("ADODB.Stream") 'riapro lo stream per spedire il file al client
if ucase(Right(sfilename,3))="TXT" then
oStr.Type = 2 'text
else
oStr.Type = 1 'binary
end if
oStr.Open
oStr.LoadFromFile sFileName 'carico lo stream col contenuto del file
Response.AddHeader "Content-Disposition", "attachment; filename=" & sFileName
Response.ContentType = rs("ContentType")
Response.BinaryWrite oStr.Read
oStr.Close
Set oStr = Nothing
Set rs = Nothing
End Sub
Function GetConnection()
dim Conn: Set Conn = CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.open "Data Source=" & Server.MapPath("/mdb-database/contatti.mdb")
set GetConnection = Conn
end function
Private Function FolderFind(byVal pathname)
Dim objFSO
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
FolderFind = objFSO.FolderExists(pathname)
Set objFSO = Nothing
End Function
%>
Fammi sapere e, comunque, grazie