Opdatér i database

Den kommer med fejlen:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

/fora/save.asp, line 103





Fejl er ekserveringen af SQL'et, hva er problemet?


Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("main.mdb")
Conn.Open DSN

title = request.form("title")
name = request.form("name")
indlaeg = request.form("indlaeg")
id = request.querystring("ID")

strSQL = "Update thread set "
strSQL = strSQL & "title = '" & title & "', "
strSQL = strSQL & "name = '" & name & "', "
strSQL = strSQL & "indlaeg = '" & indlaeg & "', "
strSQL = strSQL & "Where ID = '"  & id & "' " 


Conn.Execute(strSQL)


Conn.Close
Set Conn = Nothing
response.redirect("admin.asp")