hvad er fejlen?
hejsa jeg får denne fejl:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/philosophers corner/System Page/News/write.asp, line 36
min kode er som følger:
strSQL = "Insert into Nyheder ("
strSQL = strSQL & "Date, "
strSQL = strSQL & "Writer, "
strSQL = strSQL & "Headline, "
strSQL = strSQL & "New) "
strSQL = strSQL & "values("
strSQL = strSQL & "'" & Date & " at " & Time & "', "
strSQL = strSQL & "'" & StrUser & "', "
strSQL = strSQL & "'" & Request.Form("hl") & "', "
strSQL = strSQL & "'" & Request.Form("new") & "')"
Conn.Execute(StrSQL) <<<<<<<<<<<< linie 36
