syntaksfejl
Pls hjælp..Jeg får følgende fejl og kan ikke finde den..:UPDATE DISTINCTROW Entries SET ForumId = 17,name = 'Bubber',email = 'something@nokia.dk',subject = 'Title',comment = 'Jeg vil godt sige bla bla.',date = '08-02-00 04:52:12' WHERE id = 455
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Der er en syntaksfejl i UPDATE-sætningen.
/BOYKOT.DK/asp/kartotek/gem_ret_data.asp, linje 26
-----gem_ret_data.asp-----
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("../db/forum.mdb")
SQLstmt = "UPDATE DISTINCTROW Entries SET ForumId = " & request.form("ForumId") & ",name = '" & request.form("name") & "',email = '" & request.form("email") & "',subject = '" & request.form("subject") & "',comment = '" & request.form("comment") & "',date = '" & request.form("date") & "' WHERE id = " & Request("id")
'SQLstmt = SQLstmt & " VALUES (" & request.form("ForumId") & ",'" & request.form("name") & "','" & request.form("email") & "','" & request.form("subject") & "','" & request.form("comment") & "','" & request.form("date") & "')"
response.write sqlstmt
Conn.Execute (SQLstmt)
conn.Close
Set conn = nothing
Set SQLstmt = nothing
response.redirect ("default.asp")
%>
----------
