Number of query values and destination fields are not the same
Har en formular som jeg skal bruge til at indsætte data i access database.."Add.asp"
<form method="POST" action="add2.asp">
<table height="228" width="585">
<tr>
<td height="25" width="118">Tech. Responsible:</td><td height="25" width="453"><input type="text" name="Techresponsible" size="9"></td>
</tr><tr>
<td height="25" width="118">Date in:</td><td height="25" width="453"><input type="text" name="Datein" size="9"></td>
</tr>
<td height="25" width="118">PCName:</td><td height="25" width="453"><input type="text" name="PC_Name" size="9"></td>
<tr>
<td height="25" width="118">Date Start:</td><td><input type="text" name="Datestart" size="9"></td>
</tr>
<tr>
<td height="80" width="118">Problem:</td><td height="77" width="453"><textarea rows="5" name="Problem" cols="54"></textarea> </td>
</tr>
<tr><td height="25" width="118">Solution:</td><td height="25" width="453"><textarea rows="5" name="Solution" cols="54"></textarea>
</td>
</tr>
<tr><td height="80" width="118">Technician:</td><td width="453"><input type="text" name="Technician" size="10"></td></tr>
<tr><td height="80" width="118">Date Out:</td><td width="453"><input type="text" name="Dateend" size="10"></td></tr>
<td height="27" width="118"><input type="submit" value="Report" name="Report"><input type="reset" value="Reset" name="B2"></td>
</table>
</form>
"add2.asp"
<% strSQL = "INSERT INTO Fault (techresponsible, datein, PC_Name, datestart, problem, solution, technician, dateend) VALUES " _
& "('" & Request.Form("techresponsible") & "', " _
& "'" & Request.Form("datein") & "', " _
& "'" & Request.Form("PC_Name") & "', " _
& "'" & Request.Form("datestart") & "', " _
& "'" & Request.Form("problem") & "')" _
& "'" & Request.Form("solution") & "', " _
& "'" & Request.Form("technician") & "', " _
& "'" & Request.Form("dateend") & "')"
Conn.Execute strSQL
Response.Write "Databasen er opdateret!"
%>
Jeg får denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
add2.asp, line 14
Og umiddelbart kan jeg ikke se at der skulle være flere i den ene end den anden???
