Update crap
==========Jeg har dette på min edit side:==========<% @Language=VBScript %>
<% Option Explicit %>
<!--#include file=\"adovbs.inc\"-->
<!--#include file=\"connection.asp\"-->
<%
Dim RS, objConn, ID
\'Get the ID from the querystring
ID = trim(request.querystring(\"ID\"))
Set RS = objConn.execute(\"SELECT * FROM el WHERE ID = \" & ID & \" \" )
%>
<html>
<head><title>Edit a User</title></head>
<body>
<form action=\"updateuser.asp\" method=\"post\">
El_Siden: <input type=\"text\" name=\"Elside\" value=\"<%=RS(\"El_side\")%>\"><br>
Password: <input type=\"text\" name=\"password\" value=\"<%=RS(\"El_Billed\")%>\"><br>
<input type=\"hidden\" name=\"ID\" value=\"<%=ID%>\">
<%
rs.close
set rs = nothing
objConn.close
set objConn = nothing
%>
<input type=\"submit\" name=\"submit\" value=\"submit\">
</form></body></html>
==========Og dette på updatesiden==========
<% @Language=VBScript %>
<% Option Explicit %>
<!--#include file=\"adovbs.inc\"-->
<!--#include file=\"connection.asp\"-->
<%
Dim ID, objConn, RS, El_side, password
El_side = trim(request.form(\"Elside\"))
password = trim(request.form(\"password\"))
ID = trim(request.form(\"ID\"))
Set RS = objConn.execute(\"UPDATE el SET El_side = \' \" & El_side & \" \' , password = \' \" & password & \" \' WHERE ID = \" & ID & \" \")
%>
<html>
<head><title>Success</title></head>
<body>
You have successfully updated a user. <a href=\"users.asp\">Click here</a> to continue.
</body></html>
Når jeg kører scriptet får jeg denne fejl
Microsoft OLE DB Provider for ODBC Drivers error \'80040e10\'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/aj/aj2/admin/updateuser.asp, line 11
====Linie 11 er den her=========
Set RS = objConn.execute(\"UPDATE el SET El_side = \' \" & El_side & \" \' , password = \' \" & password & \" \' WHERE ID = \" & ID & \" \")
=============================================
Hjæææælp
