blanke felter i fil navn
Jeg har uploaded nogle billed filer til et DVD kartotek, fil navnene har blanke mellemrum f.eks. >Ringenes Herre.jpg< jeg kan godt få vist coveret, men når jeg skal redigere smider den "herre.jpg" væk.Hvad gør jeg nu??
<%
Response.Buffer = true
userid = Request.Cookies("Login")("userCode")
'build SQL statement to edit movie in DB
sqlEdit = "UPDATE DISTINCTROW movies SET mname = '" & TwoSingleQ(Request.Form("mname")) & "', mdescription = '" & TwoSingleQ(Request.Form("mdescription")) & "', myear = " & Request.Form("myear") & ", mcategory = " & Request.Form("mcat") & ", mtime = '" & TwoSingleQ(Request.Form("mtime")) & "' , mnote = '" & TwoSingleQ(Request.Form("mnote"))& "', mimagefilename = '" & TwoSingleQ(Request.Form("mimagefilename")) &"', mmovieurl = '" & TwoSingleQ(Request.Form("mmovieurl")) & "', mdirector = '" & TwoSingleQ(Request.Form("mdirector")) & "', mactors ='" & TwoSingleQ(Request.Form("mactors")) & "', mshow ='" & TwoSingleQ(Request.Form("mshow")) & "', mborrow ='" & TwoSingleQ(Request.Form("mborrow")) & "' WHERE movieID = " & Request.Form("movieid")
call openConn()
dbc.execute sqlEdit , intAffected
if intAffected = 1 then
sql = "SELECT max(movieID) from movies"
set rs = dbc.Execute(sql)
CustomID = rs(0)
call closeConn()
Session("movieid") = CustomID
Response.Redirect "main.asp"
else
call closeConn()
Response.Redirect "error.asp?msg=" & server.URLEncode("Det var ikke muligt at opdatere databasen. Prøv igen senere.")
end if
%>
