hep
har lavet nu så du kun skal rette et par småting. Har ændret i din "bruger.asp" fil hvor der måske skal rettes et link til upload-siden. Ellers er der tilføjet et pop-upscript, lukning af dine forbindelse til database, og en if-statement der tester om rs("billede") er tom. Din bruger.asp ser således ud nu:
<html>
<head>
<title>De Stolte Husarer</title>
<SCRIPT>
<!-- Begin
function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=0,location=0,statusbar=1,menubar=0,resizable=0,width=300,height=200,left = 490,top = 362');");
}
// End -->
</SCRIPT>
</head>
<body>
<font face="Arial" size="2">
<%
Sub CleanUp(rsObject)
On Error Resume Next
rsObject.Close
set rsObject = Nothing
End Sub
if request.querystring("opdater") = "fin" then
status = "Dine data er nu opdateret"
end if
if session("brugernavn") = "" then
Response.Redirect("default.asp?logud=ok")
end if
if request.querystring("logud") = "ok" then
Session.Abandon
Response.Redirect("bruger.asp")
end if
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("ant.mdb")
sql = "select * from brugerinfo where brugernavn = '" & Session("brugernavn") & "'"
Set rs = Conn.Execute(sql)
if request.querystring("opdater") = "ok" then
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("ant.mdb")
sql = "UPDATE brugerinfo SET rigtignavn = '" & request.form("rigtignavn") &"', bosat = '" & request.form("bosat") &"', Adresse ='" & request.form("adresse") &"' where brugernavn = '" & Session("brugernavn") & "'"
Conn.Execute(sql)
Conn.Close
Set Conn = Nothing
response.redirect "bruger.asp?opdater=fin"
end if
%>
</font>
<form method="POST" action="bruger.asp?opdater=ok">
<div align="center">
<table border="0" width="100%" id="table3" height="532">
<tr>
<td width="62" height="254" align="left" valign="top">
<font face="Arial" size="2">
<a id="SiteLogo1_hlLogo" href="
http://forsvaret.dk/GHR/"> <img id="SiteLogo1_imgLogo" alt="Gardehusarregimentets mærke" src="ghrlogo.jpg" border="0"></a></font></td>
<td rowspan="2" width="848" valign="top">
<p align="center"> <p align="center"> <div align="center">
<table border="1" id="table4" width="734" bordercolor="#000000">
<tr>
<td align="center" bgcolor="#008080" width="146">
<font face="Arial" size="2" color="#FFFFFF">
<a href="bruger.asp"><font color="#FFFFFF">
<span style="text-decoration: none">Din side</span></font></a></font></td>
<td align="center" bgcolor="#008080" width="146">
<font face="Arial" size="2" color="#FFFFFF">
<span style="text-decoration: none">
<a href="beskeder.asp">
<font color="#FFFFFF">
<span style="text-decoration: none">Nyeste
beskeder</span></font></a></span></font></td>
<td align="center" bgcolor="#008080" width="146" colspan="2">
<font face="Arial" size="2" color="#FFFFFF">Internt
postsystem</font></td>
<td align="center" bgcolor="#008080" width="146">
<font face="Arial" size="2" color="#FFFFFF">Billeder</font></td>
<td align="center" bgcolor="#008080" width="146">
<font face="Arial" size="2">
<a href="bruger.asp?logud=ok"><font color="#FFFFFF">
<span style="text-decoration: none">Logud</span></font></a></font></td>
</tr>
<tr>
<td align="center" bgcolor="#008080" width="365" colspan="3">
<blockquote>
<p align="left"><font color="#FFFFFF"><br>
<b><font face="Arial" size="2">Dine brugerinfo</font></b><br>
<br>
<font face="Arial" size="2">Brugernavn:
<input type="text" name="brugernavn" size="20" style="color: #FFFFFF; border: 1px solid #008080; background-color: #008080; font-family:Arial; font-size:10pt; vertical-align:bottom" value="<%=rs("brugernavn")%>" readonly><br>
<br>Navn: <font color="#FFFFFF">
<font face="Arial" size="2">
<input type="text" name="rigtignavn" size="20" style="color: #FFFFFF; border: 1px solid #008080; background-color: #008080; font-family:Arial; font-size:10pt; vertical-align:bottom" value="<%=rs("rigtignavn")%>"></font></font><br>
<br>By: <font color="#FFFFFF">
<font face="Arial" size="2">
<input type="text" name="bosat" size="20" style="color: #FFFFFF; border: 1px solid #008080; background-color: #008080; font-family:Arial; font-size:10pt; vertical-align:bottom" value="<%=rs("bosat")%>"></font></font><br>
<br>Adresse: <font color="#FFFFFF">
<font face="Arial" size="2">
<input type="text" name="adresse" size="20" style="color: #FFFFFF; border: 1px solid #008080; background-color: #008080; font-family:Arial; font-size:10pt; vertical-align:bottom" value="<%=rs("adresse")%>"><br>
<br>
<%
dim strBilledeSti
If rs("billede") <> "" Then
'hvis der er et billede
strBilledeSti = rs("billede") 'her skal du rette din attribut
Else
'angiv adresse til billede når intet er uploadet
strBilledeSti = "files\intetbillede.jpg"
End if
%>
<img border="0" src="<%=strBilledeSti%>" width="103" height="124" style="border: 1px solid #000000"><br>
</font></font></font></font>
<A HREF="java script:popUp('
http://<%=Request.ServerVariables("HTTP_HOST")%>/uploadform.asp')">Upload billede (åbner i popup-vindue)</A>
<br><br>
<input type="submit" value="Opdater data" name="B2" style="border: 1px solid #008080"></font></blockquote>
</td>
<td align="center" bgcolor="#008080" width="365" colspan="3" valign="top">
<blockquote>
<p align="left"><font color="#FFFFFF"><br>
<font face="Arial" size="2"><b>Statistik
<%
Set conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("ant.mdb")
sql = "select count(*) as antal from brugerinfo"
sql2 = "select count(*) as antal from brugerinfo where valideret = true"
set rs = Conn.Execute(sql)
set rs2 = Conn.Execute(sql2)
%>
<br>
<br>
</b>Samlet antal registrerede brugere: <%=rs("antal")%><br>
Heraf er <%=rs2("antal")%> valideret</font></font></p>
<%
'lukker recordsæts
Call CleanUp(rs)
Call CleanUp(rs2)
'lukker database forbindelsen
Conn.Close
Set Conn = Nothing
%>
</blockquote>
</td>
</tr>
</table>
</form>
</div>
<p align="center"> </td>
<td align="right" valign="top" height="254">
<font face="Arial" size="2">
<a id="SiteLogo1_hlLogo1" href="
http://forsvaret.dk/GHR/"> <img id="SiteLogo1_imgLogo1" alt="Gardehusarregimentets mærke" src="ghrlogo.jpg" border="0"></a></font></td>
</tr>
<tr>
<td width="62" height="255" align="left" valign="bottom">
<div align="center">
<font face="Arial" size="2">
<a id="SiteLogo1_hlLogo2" href="
http://forsvaret.dk/GHR/"> <img id="SiteLogo1_imgLogo2" alt="Gardehusarregimentets mærke" src="ghrlogo.jpg" border="0"></a></font></div>
</td>
<td align="right" valign="bottom" height="255">
<p>
<font face="Arial" size="2">
<a id="SiteLogo1_hlLogo0" href="
http://forsvaret.dk/GHR/"> <img id="SiteLogo1_imgLogo0" alt="Gardehusarregimentets mærke" src="ghrlogo.jpg" border="0"></a></font></td>
</tr>
<tr>
<td height="19" align="left" valign="bottom">
</td>
<td height="19" align="left" valign="top" style="border: 1px dotted #000000" bgcolor="#008080">
<b>
<font face="Arial" size="2">Statusmelding: <%=status%></font></b></td>
<td height="19" align="left" valign="bottom">
</td>
</tr>
</table>
</div>
</form>
</body>
</html>