for få parametre
Jeg prøver på at slette en post i min database med dette script:------------------------------------------------------
<%@ Language=VBScript %>
<!--esb/iss/StudentList/admin/delete.asp-->
<!--this is the delete page called by index.asp-->
<!-- #Include file = \"ADOVBS.INC\" -->
<% \'Declare all variables
dim conn
dim rs
dim strconn
dim strsql
dim record_ID
\'On Error Resume Next
strconn = \"DRIVER=Microsoft Access Driver (*.mdb);DBQ=\" & Server.MapPath(\"varer.mdb\")
record_ID = REQUEST(\"record_ID\")
%>
<html>
<head>
<title>StudentList delete page</title>
<script language=javascript type=\"text/javascript\">
<!-- hide script from old browsers
function doCancel()
{document.location = \"index.asp\"}
//End hiding script from old browser-->
</script>
</head>
<body background=\"images/flybg.gif\">
<P>
<center>
<H2 ALIGN=CENTER><B>
<p> <p>
<p> <p>
<I><FONT face=verdana SIZE=+2 color=black>Denne post vil blive slettet! </FONT></i>
<p>
<table width=\"80%\" align=\"center\" >
<form name=deleteForm action=\"index.asp\" method=post>
<input type=hidden name=reused value=yes>
<input type=hidden name=record_ID value=<%=record_ID %>>
<%
\'Setup connection and recordset objects
set conn = server.createobject(\"adodb.connection\")
conn.open strconn
set rs = server.createobject(\"adodb.recordset\")
\' get the record to fill the deleteForm
\' Set SQL statement
strSQL = \"SELECT * FROM varer WHERE ID= \" & record_ID
\'Open the Recordset object and retrieve data
rs.Open strSQL,conn, adOpenStatic
%>
<tr><td colspan=\"6\"> </td></tr>
<tr><td align=\"right\"><B>Name : </b></td>
<td align=\"left\"><input type=text name=Name size=18 maxlength=\"40\" value=\"<%=rs(\"titel\") %>\" > </td>
<td align=\"right\"><B>Site : </b></td>
<td align=\"left\"><input type=text name=isoSite size=10 value=\"<%=rs(\"beskrivelse\") %>\" > </td>
<td align=\"right\"><B>Phone : </b></td>
<td align=\"left\"><input type=text name=isoPhone size=20 maxlength=\"12\" value=\"<%=rs(\"varenummer1\") %>\" > </td>
</tr>
<tr><td colspan=\"6\"> </td></tr>
<tr><td align=\"right\"><B>School : </b></td>
<td align=\"left\"><input type=text name=isoSchool size=18 maxlength=\"20\" value=\"<%=rs(\"varenummer2\") %>\"></td>
<td align=\"right\"><B>Class : </b></td>
<td align=\"left\"><input type=text size=15 maxlength=\"20\" value=\"<%=rs(\"images\") %>\"></td>
<td align=\"right\"><B>E-mail : </b></td>
</tr>
<tr><td colspan=\"6\"> </td></tr>
<tr><td colspan=\"6\"><hr color=\"red\"></td></tr>
<tr>
<td colspan=\"3\" align=\"right\"><input type=submit name=submitAction value=\"Delete\" ></td>
<td colspan=\"3\" align=\"left\"> <input type=button name=cancel value=\"Cancel\" onclick=\"doCancel()\"></td>
</tr>
</form>
</table>
---------------------------------------------------
Men jeg får denne fejl:
-------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e10\'
[Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 1.
/ep/delete_3.asp, linje 52
Anybody?
