Syntax error i update script
Får denne fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/gem_lesson_text.asp, line 55
Update delen ser således ud:
SQL="UPDATE lesson SET "
SQL = SQL & "afsnit1='" & afsnit1 & "', "
SQL = SQL & "maintext='" & maintext & "', "
SQL = SQL & "klub='" & klub & "', "
SQL = SQL & "adresse='" & adresse & "', "
SQL = SQL & "postnr='" & postnr & "', "
SQL = SQL & "by='" & by & "', "
SQL = SQL & "telefon='" & telefon & "', "
SQL = SQL & "email='" & email & "'"
SQL = SQL & " where ID =" & Request.Querystring("ID")
/cdc
