aspsmartupload til database
Jeg har dette script som uploader 2 filer til en mappe og indskriver navnen i min database.Det jeg har brug for er at kun en fil bliver uploadet og at den updater en en post i min database.
Men jeg kan sku ikke finde ud af det.
Jeg har prøvet med denne SQL:
sql = "Update brugerinfo set '" & grafik & "' =(" & streng & ") WHERE medlemsnummer= '" & medlemsnummer & "'"
Hvor variablen grafik indholder navnet på den kollonne jeg har i min db og medlems nummer er den post som skal opdateres
<%
' Variables
' *********
Dim mySmartUpload
Dim file
Dim intCount
intCount=0
' Object creation
' ***************
Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
' Upload
' ******
mySmartUpload.Upload
' Select each file
' ****************
For each file In mySmartUpload.Files
' Only if the file exist
' **********************
If file.IsMissing = false Then
' Save the files with his original names in a virtual path of the web server
' **************************************************************************
file.SaveAs(server.mappath("files/" & file.FileName))
if CStr(intCount) = "0" then
streng = streng & "'" & file.FileName & "', "
else
streng = streng & "'" & file.FileName & "'"
end if
' sample with a physical path
'file.SaveAs("c:\" & file.FileName)
' Tæl antal filer...
' ******************************************
intCount = intCount + 1
End If
Next
' Display the number of files which could be uploaded
' ***************************************************
set rs = Server.CreateObject("ADODB.Connection")
str = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("database.mdb")
rs.open str
sql = "insert into grafiktabel(grafik1, grafik2) values(" & streng & ")"
set rs = rs.execute(sql)
Response.Write("<BR>" & mySmartUpload.Files.Count & " files could be uploaded.<BR>")
' Display the number of files uploaded
' ************************************
Response.Write(intCount & " file(s) uploaded.<BR>")
%>
default.asp
<HTML>
<BODY BGCOLOR="white">
<H1>aspSmartUpload : Sample 4</H1>
<HR>
<FORM METHOD="POST" ACTION="upload.asp" ENCTYPE="multipart/form-data" >
<INPUT TYPE="FILE" NAME="FILE1" SIZE="50"><BR>
<INPUT TYPE="FILE" NAME="FILE2" SIZE="50"><BR>
<INPUT TYPE="SUBMIT" VALUE="Upload" name="send">
</FORM>
</BODY>
</HTML>
