Semikolon ?
Hejsa.. Jeg har nedstående kode, hvor jeg får fejlen:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement.
Kan simpelthen ikke lure den, nogen som kan hjælpe :-s ?
<%
'Åbner connection til databasen
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("../mdb/QuizShow.mdb")
%>
<%
strSql = "INSERT INTO Questions (Language, Question, CorrectAnswer, Answer2, Answer3, Answer4, Nick, ApproveDate, Approved, ApprovedBy) VALUES "
strSql = strSql & "('DK','" & Request.Form("Question") & "','" & Request.Form("CorrectAnswer") & "','" & Request.Form("Answer2") & "','" & Request.Form("Answer3") & "','" & Request.Form("Answer4") & "','" & Request.Form("Nick") & "','" & Now() & "',True,'" & Request.Form("ApprovedBy") & "') Where Questionnr ='" & Request.QueryString("ID") & "';"
conn.execute(strSql)
%>