I have these two pages set up so that users may change there info but I think the database connection isnt working look at this and see what you think. Also how does each user change there own setting I have 25 members so they would need to login for it to display there information wouldn't they.?
if so how
do I need a <%@LANGUAGE="VBSCRIPT"%> at the top of the pages
Another question is that is that does this connection require a path /writedatabase/membersragol.mdb
<----this is the first page-------->
<html>
<head>
<title>Member Update Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("Membersragol.mdb"
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset"
Rs.Open "SELECT * FROM Membersragol WHERE name = '" &Request.Form("name" &"'
AND password = '" &Request.Form("password" &"'", Conn, 1, 3
%>
Current Level: <%=RS("name"%>
Password: <%=RS("password"%>
<form name="form1" method="post" action="update.asp">
<input type="hidden" value="<%=RS("password"%>" name="oldpassword">
<input type="hidden" value="<%=RS("name"%>" name="username">
<p>Level:
<input type="text" name="level" size="20">
</p>
<p>Password:
<input type="text" name="pass" size="20">
</p>
<p>
<input type="submit" value="Submit" name="B1">
</p>
</form>
</body>
</html>
<-----It post's to this page called update.asp------>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("Membersragol.mdb"
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset"
Rs.Open "SELECT * FROM Membersragol WHERE name = '" &Request.Form("name" &"'
AND password = '" &Request.Form("oldpassword" &"'", Conn, 1, 3
Rs("level" = Request.Form("level"
Rs("password" = Request.Form("oldpassword"
Rs.Update
Rs.close
Set RS = Nothing
Set Conn = Nothing
Response.Write "Updated database"
%>
</body>
</html>
if so how
do I need a <%@LANGUAGE="VBSCRIPT"%> at the top of the pages
Another question is that is that does this connection require a path /writedatabase/membersragol.mdb
<----this is the first page-------->
<html>
<head>
<title>Member Update Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("Membersragol.mdb"
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset"
Rs.Open "SELECT * FROM Membersragol WHERE name = '" &Request.Form("name"
&"'AND password = '" &Request.Form("password"
&"'", Conn, 1, 3%>
Current Level: <%=RS("name"
%> Password: <%=RS("password"
%> <form name="form1" method="post" action="update.asp">
<input type="hidden" value="<%=RS("password"
%>" name="oldpassword"><input type="hidden" value="<%=RS("name"
%>" name="username"><p>Level:
<input type="text" name="level" size="20">
</p>
<p>Password:
<input type="text" name="pass" size="20">
</p>
<p>
<input type="submit" value="Submit" name="B1">
</p>
</form>
</body>
</html>
<-----It post's to this page called update.asp------>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<%
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("Membersragol.mdb"
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset"
Rs.Open "SELECT * FROM Membersragol WHERE name = '" &Request.Form("name"
&"'AND password = '" &Request.Form("oldpassword"
&"'", Conn, 1, 3Rs("level"
= Request.Form("level"Rs("password"
= Request.Form("oldpassword"Rs.Update
Rs.close
Set RS = Nothing
Set Conn = Nothing
Response.Write "Updated database"
%>
</body>
</html>
