Insert into script som brokker sig
Hvorfor siger Explore:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen.
/Regning/index.asp, line 118
Linie 118 = "Conn.Execute(strSaveScore)"
-----------------------------------
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("..\db\regning.mdb")
Conn.Open DSN
strUserSQL = "Select * from Users where Username = '" & Session("MM_Username") & "'"
Set UserInfo = Conn.Execute(strUserSQL)
setUserDataSQL = "Select * from ScoreTable where UserID = " & UserInfo("UserID")
Set UserData = Conn.Execute(setUserDataSQL)
-----
strSaveScore = "Insert into ScoreTable ("
strSaveScore = strSaveScore & "UserID, "
strSaveScore = strSaveScore & "Level, "
strSaveScore = strSaveScore & "AntalRigtige, "
strSaveScore = strSaveScore & "AntalForkerte, "
strSaveScore = strSaveScore & "Point, "
strSaveScore = strSaveScore & "Tid"
strSaveScore = strSaveScore & ") Values( "
strSaveScore = strSaveScore & "'" & UserInfo("UserID") & "', "
strSaveScore = strSaveScore & "'" & Diffecaulty/5 & "', "
strSaveScore = strSaveScore & "'" & Rigtig & "', "
strSaveScore = strSaveScore & "'" & Forkert & "', "
strSaveScore = strSaveScore & "'" & Point & "', "
strSaveScore = strSaveScore & "'" & Timer-Request.Form("Mysec") & "')"
Conn.Execute(strSaveScore)
---
conn.close osv....
