Insert Into problem
HejzaEr der nogen der kan sige mig hvorfor jeg for denne fejl ved i forbindelse med de to sider:
Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen.
/html/medlem/cv/send.asp, line 5
Browsertype:
Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Side:
POST 148 bytes to /html/medlem/cv/send.asp
Default.asp:
<form name=\"form1\" method=\"post\" action=\"send.asp\">
<table width=\"323\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr>
<td width=\"98\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">Navn:</font></td>
<td width=\"225\">
<input type=\"text\" name=\"Navn\" class=\"input\" size=\"20\">
</td>
</tr>
<tr>
<td width=\"98\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">Adresse:</font></td>
<td width=\"225\">
<input type=\"text\" name=\"Adr\" class=\"input\" size=\"20\">
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">By/Post nr.</font></td>
<td width=\"225\">
<input type=\"text\" name=\"City\" class=\"input\" size=\"20\" value=\" /\">
</td>
</tr>
<tr>
<td width=\"98\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">Tlf.
nr:</font></td>
<td width=\"225\">
<input type=\"text\" name=\"Tlf\" class=\"input\" size=\"20\">
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">E-Mail:</font></td>
<td width=\"225\">
<input type=\"text\" name=\"Mail\" class=\"input\" size=\"20\">
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">Interresser:</font></td>
<td width=\"225\">
<textarea name=\"Int\" class=\"input\"></textarea>
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">Tidliger job:</font></td>
<td width=\"225\">
<textarea name=\"Job\" class=\"input\"></textarea>
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">Alder:</font></td>
<td width=\"225\">
<input type=\"text\" name=\"Alder\" class=\"input\">
</td>
</tr>
<tr>
<td width=\"98\"><font size=\"2\">Køn:</font></td>
<td width=\"225\"> <font size=\"2\">
<select name=\"Kon\" class=\"input\">
<option value=\"Han\">Han</option>
<option value=\"Hun\">Hun</option>
</select>
</font></td>
</tr>
<tr>
<td width=\"98\"> </td>
<td width=\"225\"> </td>
</tr>
<tr>
<td width=\"98\"> </td>
<td width=\"225\">
<div align=\"center\">
<input type=\"submit\" name=\"Submit\" value=\"Send\" class=\"input\">
</div>
</td>
</tr>
</table>
</form>
send.asp:
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"/log/ungdb.mdb\")
SQL=\"INSERT Into cv (navn,adr,city,tlf,mail,int,job,alder,kon) VALUES (\'\"&request.form(\"Navn\")&\"\',\'\"&request.form(\"Adr\")&\"\',\'\"&request.form(\"City\")&\"\',\'\"&request.form(\"Tlf\")&\"\',\'\"&request.form(\"Mail\")&\"\',\'\"&request.form(\"Int\")&\"\',\'\"&request.form(\"Job\")&\"\',\'\"&request.form(\"Alder\")&\"\',\'\"&request.form(\"Kon\")&\"\')\"
Conn.Execute(SQL)
%>
--
Michael
