problmer med opdatering
haves en side med personlige stamoplysninger.disse oplysninger hentes ud i en masse editboxe. og kan rettes når man Submitter sker der bare ingenting, med mindre man tryker på knappen "slet mig selv" :(
her er koden:
<%
if Request.ServerVariables("REQUEST_METHOD") = "POST" then
if request("Submit") = "Submit" then
response.write("noller42")
set conn = server.createobject("adodb.connection")
conn.open strdsn
conn.execute("update personer set navn = '"&request.form("edtnavn")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set adresse = '"&request.form("edtadresse")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set postnr = '"&request.form("edtpostnr")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set bynavn = '"&request.form("edtbynavn")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set telefon = '"&request.form("edttelefon")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set email = '"&request.form("edtemail")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set icq = '"&request.form("edticq")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set homepage = '"&request.form("edthomepage")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set gruppe_id = 1 where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set password = '"&request.form("edtpassword")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.execute("update personer set bemærkninger = '"&request.form("edtbemærkninger")&"' where kaldenavn = '"&request("kaldenavn")&"'")
conn.close
response.redirect("stamoplys.asp")
end if
if request("submit") = "Slet mig selv" then
set conn = server.createobject("adodb.connection")
conn.open strdsn
conn.execute("delete * from personer where personer.kaldenavn = '"&request("kaldenavn")&"'")
response.write("SLET")
response.redirect("logoff.asp")
end if
end if
%>
<br>
<hr>
<%
set conn = server.createobject("adodb.connection")
conn.open strdsn
set user = conn.execute("select * from personer where kaldenavn = '"& session("kaldenavn")&"'")
%>
<form method="post" action="stamoplys.asp" name="skod">
<table width="100%" border="0">
<tr>
<td width="10%">kaldenavn</td>
<td width="20%"> <b><%=user("kaldenavn")%>
<input type="hidden" name="kaldenavn2" value="<%=user("kaldenavn")%>">
</b></td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%">navn</td>
<td width="20%">
<input type="text" name="edtnavn" value="<%=user("navn")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%">adresse</td>
<td width="20%">
<input type="text" name="edtadresse" value="<%=user("adresse")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%" height="16">postnr</td>
<td width="20%" height="16">
<input type="text" name="edtpostnr" value="<%=user("postnr")%>">
</td>
<td width="9%" height="16"> </td>
<td width="61%" height="16"> </td>
</tr>
<tr>
<td width="10%">by</td>
<td width="20%">
<input type="text" name="edtbynavn" value="<%=user("bynavn")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%" height="31">telefon</td>
<td width="20%" height="31">
<input type="text" name="edttelefon" value="<%=user("telefon")%>">
</td>
<td width="9%" height="31"> </td>
<td width="61%" height="31"> </td>
</tr>
<tr>
<td width="10%">email</td>
<td width="20%">
<input type="text" name="edtemail" value="<%=user("email")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%">ICQ</td>
<td width="20%">
<input type="text" name="edticq" value="<%=user("ICQ")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%">homepage</td>
<td width="20%">
<input type="text" name="edthomepage" value="<%=user("homepage")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%">gruppe</td>
<td width="90%" colspan="3"> <%
set conn1 = server.createobject("adodb.connection")
conn1.open strdsn
set opslag = conn1.execute("select * from grupper order by gruppenavn desc")
if opslag.eof = -1 then
response.write("ingen grupper")
else
%>
<select name="edtgruppe" width="23">
<%
do until opslag.eof
%>
<option value="<%=opslag("gruppe_id")%>" <%if user("gruppe_id") = opslag("gruppe_id") then response.write("selected") end if %> ><%=opslag("gruppenavn")%>
<%
opslag.movenext
loop
end if
%>
</select>
Hvis dit hold ikke findes på listen kan du oprette et
<a href="opret_gruppe.asp">her </a> </td>
</tr>
<tr>
<td width="10%">password</td>
<td width="20%">
<input type="password" name="edtpassword" value="<%=user("password")%>">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr align="left" valign="top">
<td width="10%">bemærkninger</td>
<td width="20%">
<textarea name="edtbemærkninger" rows="5" cols="30"><%=user("bemærkninger")%></textarea>
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%"> </td>
<td width="20%">
<input type="submit" name="Submit" value="Submit">
</td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%"> </td>
<td width="20%"> </td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%"> </td>
<td width="20%"> </td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
<tr>
<td width="10%"> </td>
<td width="20%"> </td>
<td width="9%"> </td>
<td width="61%"> </td>
</tr>
</table>
</form>
<form method="post" action="stamoplys.asp" name="">
<b>Oplysninger for Bruger: "<%=user("navn")%>"
<input type="hidden" name="kaldenavn" value="<%=user("kaldenavn")%>">
</b>
<input type="submit" name="submit" value="Slet mig selv">
</form>
<p> </p>
------- slut -------
hvad er der galt ?
