Og her hentes fra databasen igen - med formål at kunne redigere (kampRed.asp)
<!--#include file ="../../opendb.asp"-->
<!--#include file ="../../LoginTest.asp"-->
<html>
<head>
<link rel="stylesheet" type="text/css" href="../../../style.css">
<%
sql= "select * from TKampe order by Kamp"
set rs = conn.execute(sql)
arrKampe = rs.GetRows
id = request.querystring("ID")
if id = "" then
sql= "select top 1 * from TKampe order by Kamp"
else
sql= "select * from TKampe where KampID=" & id
end if
set rs = conn.execute(sql)
arrKamp = rs.GetRows
%>
<script language="javascript">
function checkEmpty(thisElement)
{
if (document.getElementById(thisElement).value == "")
return true;
else
return false;
}
function formvalidation(thisform)
{
if (checkEmpty("Kamp"))
{
alert("Du mangler at skrive hvem der har spillet!");
document.getElementById("Kamp").focus();
return false;
}
else if (checkEmpty("Score"))
{
alert("Du mangler at skrive en score for kampen!");
document.getElementById("Score").focus();
return false;
}
else if (checkEmpty("Dato"))
{
alert("Du mangler at skrive en dato!");
document.getElementById("Dato").focus();
return false;
}
else
return true;
}
function getKampe()
{
var id=document.getElementById("id").options[document.getElementById("id").selectedIndex].value;
location.href="kampeRed.asp?id="+id;
}
</script>
</head>
<body bgcolor="#999966">
<FORM method="POST" name="kampForm" ACTION="kampeRedSubmit.asp?id=<%=id%>" onsubmit="return formvalidation(this)">
<table border="0" cellpadding="3" cellspacing="0" width="100%" height="98%" bgcolor="#999966" align="center" valign="middle">
<tr>
<td valign="top">
<table border="0" height="98%">
<tr>
<td width="200" height="120" align="left" valign="top" colspan="2">
<font face=Verdana size=2><b>Rediger en kamp</b><br>
<font face=Verdana size=1><p align="justify">
Du kan herfra redigere en kamp spillet i [CoZe].</p>
</td>
</tr>
<tr>
<td align="center">
<% if request.queryString("update") ="true" THEN %>
<font face="Verdana" size="1"><b>Profilen er nu redigeret!</b>
<%else%>
<A HREF="#"
onClick="java script:if (formvalidation(this)) document.kampForm.submit();">
<img border="0" src="../../Billeder/buttonOpdater.gif" width="81" height="20" cursor="hand">
</A>
<% end if %>
</td>
</tr>
</table>
</td>
<td width="400" align="center" valign="top">
<table border="0" bordercolor="#D42222" bgcolor="#999966" width="100%" height="98%" cellpadding="0" cellspacing="0">
<tr><td><font face=Verdana size=1><b>Vælg en kamp: </b></td></tr>
<tr><td align="left" valign="top">
<select name="kamp" size=1 id="id" onChange="getKampe();">
<%for i = 0 to Ubound(arrKampe,2)%>
<%if Trim(arrKampe(0,i)) = Trim(ID) then%>
<option value="<%=arrKampe(0,i)%>" selected><%=arrKampe(1,i)%> </option>
<%else%>
<option value="<%=arrKampe(0,i)%>"><%=arrKampe(1,i)%> </option>
<%end if%>
<%next%>
</select>
</td></tr>
<tr><td><font face=Verdana size=1><b>Kamp: </b></font></td></tr>
<tr><td><input type=text name="Kamp" value="<%=arrKamp(1,0)%>" size="60"></td></tr>
<tr><td><font face=Verdana size=1><b>Score: </b></font></td></tr>
<tr><td><input type=text name="Score" value="<%=arrKamp(2,0)%>" size="60"></td></tr>
<tr><td><font face=Verdana size=1><b>Dato: </b></font></td></tr>
<tr><td><input type=text name="Dato" value="<%=arrKamp(3,0)%>" size="60"></td></tr>
<tr><td colspan="2"><font face=Verdana size=1><b>Blev kampen spillet i SLAP.dk? </b></font>
<% If rs("Slap") = true THEN %>
<input type="checkbox" name="Slap" checked>
<% else %>
<input type="checkbox" name="Slap">
<% End If %>
</td>
</tr>
</table>
</td>
</tr>
</table>
</FORM>
</body>
</html>
