database + ASP
Hvad har jeg gjort forkert?På forhånd tak!!
Med venlig hilsen martin
<%@ language=VBScript %>
<% option explicit %>
<!--#include file=\"adovbs.inc\"-->
<!--#include file=\"DatabaseConnect.asp\"-->
<%
Dim objRS
Set objRS = Server.createObject(\"ADODB.Recordset\")
objRS.Open \"Users\", objConn, , adLockOptimistic, adCmdTable
objRS.AddNew
objRS(\"FirstName\") = Request.Form(\"firstname\")
objRS(\"LastName\") = Request.Form(\"lastname\")
objRS(\"e-mail\") = Request.Form(\"e-mail\")
objRS(\"username\") = request.form(\"username\")
objRS(\"password\") = request.form(\"password\")
((linie 15)) objRS.Update
objRS.close
Set objRS = nothing
objConn.close
Set objConn = nothing
%>
<html>
<body bgcolor=\"#FFFFFF\" text=\"#000000\">
Thank you for registering
</body>
</html>
Browser:
Microsoft OLE DB Provider for ODBC Drivers fejl \'80004005\'
[Microsoft][ODBC Microsoft Access-driver] Syntax error in INSERT INTO statement.
/asp/linje 15
