ASPUpload til Database
Hvordan løser jeg denne ? Jeg kan ikke få kontakt til databasen eller så er det forkerte felter ?FILE = OLE-Objekt
FILENAME = Tekst
side1.asp:
<form method=\"post\" enctype=\"multipart/form-data\" action=\"uploaded.asp\">
<input type=\"file\" name=\"file1\"><br>
<input type=\"submit\" value=\"upload!\">
</form>
uploaded.asp
(Denne side gemmer biledet i en access database)
Dim Upload, File
set Upload = Server.CreateObject(\"Persits.Upload.1\")
Upload.OverwriteFiles = False
Upload.Save \"d:\\sti\\til\\skrive\\omraade\"
For Each File in Upload.Files
Dim SQL
SQL = \"UPDATE users SET FILENAME=\"& File.Path &\", FILE=? WHERE username=\'\"& session(\"username\") &\"\';\"
File.ToDatabase \"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=d:\\stil\\til\\database.mdb;\", SQL
if Err <> 0 Then
Response.Write \"Error saving the file: \" & Err.Description
Else
File.Delete
Response.Write \"Success!\"
end If
next
