Har prøvet at få disse 2 sider til at opdatere min database ved hjælp af en form, men det virker ikk... hva er der galt ???
her er changepass.asp:
<form method="post" action="change.asp">
<table border="0" cellspacing="0" width="228" height="125">
<tr>
<td width="78" height="25"><p>Password:</td>
<td width="165" height="25"><input type="password" name="Password"></td>
</tr>
<input type="hidden" Name="Mode" Value="change"></td>
<tr>
<td width="78" height="25"><input type="submit" value="Change"></td>
</td>
</table>
</form>
og her er change.asp:
<%
if request ("mode") = "change" then
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("database.mdb")
Conn.Open DSN
strSQL = "Update admin set "
strSQL = strSQL & " password = Request.Form('Password')"
strSQL = strSQL & " Where login = Session('ID')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
else
Response.redirect "defaultlogged.asp"
end IF
%>