Hvor er min fejl?
Hejsa!Jeg sender data fra denne side:
<FORM ACTION=\"gemnykunde.asp\" METHOD=\"POST\" NAME=\"Nye\">
<TABLE BORDER=1>
<TR>
<TD>DN Kundenr</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"8\" MAXLENGTH=\"5\" NAME=\"DNKundenr\"></TD>
</TR>
<TR>
<TD>Navn</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"40\" MAXLENGTH=\"50\" NAME=\"Navn\"></TD>
</TR>
<TR>
<TD>Tlf</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"20\" MAXLENGTH=\"20\" NAME=\"Tlf\"></TD>
</TR>
<TR>
<TD>Email</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"50\" MAXLENGTH=\"100\" NAME=\"Email\"></TD>
</TR>
<TR>
<TD>Postnr</TD>
<TD><TEXTAREA WRAP=\"physical\" ROWS=\"5\" COLS=\"51\" NAME=\"Postnr\"></TEXTAREA></TD>
</TR>
<TR>
<TD>By</TD>
<TD><TEXTAREA WRAP=\"physical\" ROWS=\"5\" COLS=\"50\" NAME=\"By\"></TEXTAREA></TD>
</TR>
<TR>
<TD>Adresse</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"5\" MAXLENGTH=\"5\" NAME=\"Adresse\"></TD>
</TR>
<TR>
<TD>Oprettet</TD>
<TD><INPUT type=\"text\" name=\"Oprettet\"></TD>
</TR>
<TR>
<TD>Hotline</TD>
<TD>Ja<INPUT TYPE=\"radio\" NAME=\"Hotline\" value=\"Ja\" Checked>
Nej<INPUT TYPE=\"radio\" NAME=\"Hotline\" value=\"Nej\"></TD>
</TR>
<TR>
<TD>Version</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"20\" NAME=\"Version\"></TD>
</TR>
<TR>
<TD>Antal brugere</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"20\" NAME=\"Antal\"></TD>
</TR>
<TR>
<TD>Kommentar</TD>
<TD><TEXTAREA WRAP=\"physical\" ROWS=\"5\" COLS=\"51\" NAME=\"Kommentar\"></TEXTAREA></TD>
</TR>
</TABLE>
<INPUT TYPE=\"submit\" VALUE=\"Registrer\"> <INPUT TYPE=\"reset\" VALUE=\"Rens felter\">
Til denne side:
<%DIM CONNECT, ONGemNye
SET CONNECT = SERVER.CREATEOBJECT(\"ADODB.CONNECTION\")
CONNECT.OPEN \"DRIVER={Microsoft ACCESS DRIVER (*.MDB)}; DBQ=\" & Server.MapPath (\"al-dente.MDB\")%>
<%SET ONGemNye = CONNECT.EXECUTE (\"INSERT INTO kunder (DNKundenr, Navn, tlf, email, Postnr, By, Adresse, Oprettet, Hotline, Version, Antal, Kommentar) VALUES (\"+ REQUEST.form(\"DNKundenr\")+\",\'\"+ REQUEST.form(\"Navn\")+\"\',\'\"+ REQUEST.form(\"Tlf\")+\"\',\'\"+ REQUEST.form(\"Email\")+\"\',\'\"+ REQUEST.form(\"Postnr\")+\"\',\'\"+ REQUEST.form(\"By\")+\"\',\'\"+ REQUEST.form(\"Oprettet\")+\"\',\'\"+ REQUEST.form(\"Adresse\")+\"\',\'\"+ REQUEST.form(\"Hotline\")+\"\',\'\"+ REQUEST.form(\"Version\")+\"\',\"+ REQUEST.form(\"Antal\") +\",\'\"+ REQUEST.form(\"Kommentar\") +\"\')\")%>
Men det resulterer i følgende fejl:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Jeg kan ikke rigtig gennemskue hvorhenne jeg har fejlen, håber at der er nogen af jer der kan
