Frågan#1
Hej,
Försöker att ladda tre filer(bilder) till mappen bilder och sedan spara filnamnet i databasen.
Uppladdningen fungerar filerna hamnar i mappen bilder som det ska men inte i databasen alltså filnamnet sparas men med samma namn (strFilename).
Hur skall jag gå till väga med (strFilename1 och strFilename2)
Felet ligger här tror jag?
[b]
If Not File Is Nothing Then
StrFilename=file.filename
StrFilename1=file.filename
StrFilename2=file.filename
End if
[/b]
Hela koden:
<% Set Upload = Server.CreateObject("Persits.Upload")
Upload.Save(Server.MapPath("../bilder/"))
Set File = Upload.Files("blob")
Set File = Upload.Files("blob1")
Set File = Upload.Files("blob2")
item = Upload.form("item")
description = Upload.form("description")
sal= Upload.form("sal")
mark= Upload.form("mark")
category = Upload.form("category")
ja = Upload.form("ja")
price = Upload.form("price")
phone = Upload.form("phone")
email = Upload.form("email")
stad = Upload.form("stad")
password = Upload.form("password")
If Not File Is Nothing Then
StrFilename=file.filename
StrFilename1=file.filename
StrFilename2=file.filename
End if
' Build ODBC connection string
Connect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\db\annonser.mdb")
SQL= "INSERT INTO mak (item, description,typ,markerad, category, test,price,phone,email,stad, filename,filename1,filename2,password)"
SQL= "INSERT INTO items (item, description,typ,markerad, category, test,price,phone,email,stad, filename,password,lan) VALUES('" & item & "','"& description & "','" & sal &"','" & mark&"','" &category &"','"&ja& "','"&price&"','"&phone&"','"& email &"', '"&stad&"','"&strFilename& "','"&strFilename1& ",'"&strFilename2& ",'"& password & '”)"
%>
<meta http-equiv="Refresh" content="0; URL=redir.asp">
</body>
</html>