HASTER-> Find EN fejl
<%Dim RS
Set conn = Server.CreateObject(\"ADODB.Connection\")
DBPath = \"DBQ=\" & server.mappath(\"db.mdb\")
conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; \" & DBPath
%>
<%
Sql = \"Insert into brugere (brugernavn, password, navn, alder, icq, email, postnummer, by) values(\'\"
Sql = Sql & session(\"bruger\") & \"\',\'\"
Sql = Sql & session(\"password\") & \"\',\'\"
Sql = Sql & Request.form(\"navn\") & \"\',\'\"
Sql = Sql & Request.form(\"alder\") & \"\',\'\"
Sql = Sql & Request.form(\"icq\") & \"\',\'\"
Sql = Sql & Request.form(\"email\") & \"\')\"
Sql = Sql & Request.form(\"postnummer\") & \"\')\"
Sql = Sql & Request.form(\"by\") & \"\')\"
conn.Execute(Sql)
conn.Close
%><meta http-equiv=\'refresh\' content=\'0;URL=oprettet.asp\'>
Får denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
addpost.asp, line 20
Hvad er der galt ?