ASP Script - fejl ved SQL insert
Hej,Jeg har et ASP scrpt som fejler efter at det er flyttet til et nyt webhotel med en ny ASP Upload komponent.
Får flg fejl ved oprettelse af nye poster i access databaseb:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(,,,,,'',,'3.jpg');'.
/pages/new_car_save.asp, line 45
Linje 45 er:
SQL ="INSERT INTO biler (maerke, model, aargang, maaned, km, remarks, pris" & vPicName & ") values ("
SQL = SQL & "(" & vMaerke & "," & vModel & "," & vAargang & "," & vMaaned & "," & vKm & ",'" & vRemarks & "'," & vPris & vPic & ");"
Hele scriptet:
<!--#include file="../inc/connect_db_pages.asp" -->
<%
Dim vUpload, item, value, file
Set vUpload = Server.CreateObject("Persits.Upload")
vUpload.Save(server.MapPath("../images/uploads"))
Dim vMaerke, vModel, vAargang, vMaaned, vKm, vRemarks, vBillede, vPris
For each item In vUpload.form
for each value in vUpload.form
Select case ucase(item)
Case "MAERKE"
vMaerke="'" & value & "'"
Case "MODEL"
vmodel="'" & value & "'"
Case "AARGANG"
vAargang=value
Case "MAANED"
vMaaned=value
Case "KM"
vKm=value
Case "REMARKS"
vRemarks=value
Case "PRIS"
vPris=value
Case else
End Select
Next
Next
vBillede=vUpload.files(1).Filename
dim vPic, vPicName
if vBillede="" then
vPic=""
vPicName=""
else
vPic=",'" & vBillede & "'"
vPicName=",billede"
end if
SQL ="INSERT INTO biler (maerke, model, aargang, maaned, km, remarks, pris" & vPicName & ") values ("
SQL = SQL & "(" & vMaerke & "," & vModel & "," & vAargang & "," & vMaaned & "," & vKm & ",'" & vRemarks & "'," & vPris & vPic & ");"
Conn.Execute(SQL)
Conn.Close
Set Conn = Nothing
Set vUpload = Nothing
Response.Redirect "caradmin.asp"
%>
Er der nogen der kan se hvad fejlen er? PÅ forhånd tak.,,