så gerne hr. :-)
<% @LANGUAGE = JavaScript %>
<%
rs_aftaler = Server.CreateObject(\"ADODB.Recordset\");
get_aftaler = \"SELECT leverandor.L_id, leverandor.leverandor, mus.M_id, mus.navn, mus.model, mus.model_nr, mus.hand, mouse_deal.Md_id, mouse_deal.init, mouse_deal.status, mouse_deal.dato_udlaan, mouse_deal.dato_retur, mouse_deal.rykket_dato, mouse_deal.kommentar FROM leverandor, mouse_deal, mus WHERE mus.m_id = mouse_deal.mus_id And mus.lev_id = leverandor.l_id;\"
%>
<html>
<head>
<link rel=\"stylesheet\" type=\"text/css\" href=\"ebbecss.css\">
<title>Musse udlån</title>
</head>
<body>
<table border=\"1\" align=\"center\" cellspacing=\"0\">
<tr>
<td width = \"20\"><h2>Init</h2></td>
<td width = \"80\"><h2>Status</h2></td>
<td width = \"80\"><h2>Udlånt dato</h2></td>
<td width = \"80\"><h2>Retur dato</h2></td>
<td width = \"80\"><h2>Rykket dato</h2></td>
<td width = \"80\"><h2>Kommentar</h2></td>
</tr>
<%
rs_aftaler.Cursortype = 1;
rs_aftaler.Open(get_aftaler,\"mouse\");
while(!rs_aftaler.EOF)
{%>
<%
init = rs_aftaler(\"init\");
status = rs_aftaler(\"status\");
dato_udlaan = rs_aftaler(\"dato_udlaan\");
dato_retur = rs_aftaler(\"dato_retur\");
rykket_dato = rs_aftaler(\"rykket_dato\");
kommentar = rs_aftaler(\"kommentar\");
mus_id = rs_aftaler(\"m_id\");
navn = rs_aftaler(\"navn\");
leverandor = rs_aftaler(\"leverandor\");
%>
<tr>
<td colspan = \"8\"><h2><a href=\"getmouse.asp?id=<%Response.write(mus_id)%>\"><%Response.write(navn)%></a></h2></td>
</tr>
<form>
<tr>
<td><input type = \"text\" size = \"6\" value = \"<%Response.write(init)%>\"></td>
<td><input type = \"text\" size = \"10\" value = \"<%Response.write(status)%>\"></td>
<td><input type = \"text\" size = \"10\" value = \"<%Response.write(dato_udlaan)%>\"></td>
<td><input type = \"text\" size = \"10\" value = \"<%Response.write(dato_retur)%>\"></td>
<td><input type = \"text\" size = \"10\" value = \"<%Response.write(rykket_dato)%>\"></td>
<td><input type = \"text\" size = \"30\" value = \"<%Response.write(kommentar)%>\"></td>
<td><input type = \"button\" class = \"button\" value = \"Opdater\"</td>
</tr>
</form>
<%
rs_aftaler.MoveNext();
}
%>
</table>
<%
rs_aftaler.Close;
%>
</td>
</tr>
</table>
</body>
</html>
