Password ændring fra side på nettet..
Hej.Jeg har lavet en database med brugernavn og password.
Nu vil jeg gerne have en side så folk selv kan ændre deres password fra en side. jeg har forsøgt at lave noget, men det virker ikk.
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>
change.asp:
<!--#include file="beskyt.asp"-->
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("database.mdb")
Conn.Open DSN
Password = Request.Form("Password")
Login = Session("ID")
strSQL = "Update admin set password ='" Password &"' Where login ="& login &";"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
Response.redirect "defaultlogged.asp"
%>
fejlen :
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/tmkguild/change.asp, line 10
strSQL = "Update admin set password ='" Password &"' Where login ="& login &";"
----------------------------------------^
Pilen stopper ved P'et i '" Password &"
