Det var ganske rigtigt: Nu henter den mit data ind på siden vis_bolig.asp, men der er kommet et andet lille problem.
Siden vis_bolig.asp bliver loopet så mange gange at siden går ned, hvad er problemet??
Jeg har hele min kode her for vis_bolig.asp:
<%
set cn = server.createobject("adodb.connection")
cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\Ejendom\db\Ejendom.mdb;"
SagNr = request.querystring("id")
sql = "SELECT * FROM Hovedtabel WHERE sagsnummer = " & SagNr
Set objRec = cn.Execute(sql)
while not objRec.eof
%>
<html>
<head>
<title>Ejendom</title>
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body background="billeder/bag.gif" text="#000000" topmargin="5">
<table width="760" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#000000">
<tr>
<td>
<table width="760" border="0" cellspacing="0" cellpadding="0" height="274" align="center">
<tr bgcolor="#006699">
<td height="80" colspan="2"></td>
</tr>
<tr>
<td height="16" bgcolor="#006699"></td>
<td height="16" bgcolor="#FFFFFF">
<table width="610" border="0" cellspacing="0" cellpadding="0">
<tr>
<a style="cursor: hand"; href="#"><td bgcolor="#de7e18" width="90" height="16">
<div align="center" class="twkst">Køb</div>
</td>
<td width="9" background="billeder/menu.gif" height="16"></td></a>
<td width="5" bgcolor="#006699" height="16"></td>
<td bgcolor="#de7e18" width="90" height="16">
<div align="center" class="twkst">Salg </div>
<td width="10" background="billeder/menu.gif" height="16"></td>
<td width="5" bgcolor="#006699" height="16"></td>
<td bgcolor="#de7e18" width="90" height="16">
<div align="center" class="twkst">Vurdering </div>
<td width="10" background="billeder/menu.gif" height="16"></td>
<td width="5" bgcolor="#006699" height="16"></td>
<td bgcolor="#de7e18" width="90" height="16">
<div align="center" class="twkst">Kontakt </div>
<td width="10" background="billeder/menu.gif" height="16"></td>
<td width="90" bgcolor="#006699" height="16"></td>
<td width="90" bgcolor="#006699" height="16"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="150" valign="top" bgcolor="#EEEEEE"></td>
<td bgcolor="FFFFFF" rowspan="7" valign="top">
<table width="600" border="0" cellspacing="0" cellpadding="0" height="100%" align="center">
<tr>
<td height="9"></td>
</tr>
<tr>
<td height="218" valign="top">
<%=objRec("Gadenavn")%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="150" valign="top" bgcolor="#EEEEEE">
<table width="140" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#999999">
<tr>
<td valign="top" bgcolor="#CCCCCC">
<div align="center"><span class="twkst">KVIKSØG</span></div>
</td>
</tr>
<tr>
<td valign="top">
<Form name="soeg" method="post" action="soeg.asp" style="margin:2px;">
<input type="hidden" name="send" value="ja">
<table width="140" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td width="5"></td>
<td class="twkst">Sagsnummer:</td>
</tr>
<tr>
<td></td>
<td>
<input type="text" name="sagsnr" class="border">
</td>
</tr>
<tr>
<td colspan="2"height="5"></td>
</tr>
<tr>
<td height="3"></td>
<td height="3" class="twkst">By:</td>
</tr>
<tr>
<td height="2"></td>
<td height="2">
<input type="text" name="by" class="border">
</td>
</tr>
<tr>
<td colspan="2"height="5"></td>
</tr>
<tr>
<td></td>
<td class="twkst">Gadenavn:</td>
</tr>
<tr>
<td height="2"></td>
<td height="2">
<input type="text" name="Gadenavn" class="border">
</td>
</tr>
<tr>
<td colspan="2"height="3"></td>
</tr>
<tr>
<td height="3"></td>
<td height="3"><input type="image" src="billeder/soeg.gif" border="0"></td>
</tr>
<tr>
<td colspan="2"height="5"></td>
</tr>
<tr>
<td colspan="2"height="2" width="140" background="billeder/streg.gif"></td>
</tr>
<tr>
<td></td>
<td class="twkst" height="20" valign="bottom">Boligtype:</td>
</tr>
<tr>
<td></td>
<td>
<select name="Type" class="border">
<option value="villa" selected>Villa</option>
<option value="r_hus">Rækkehus</option>
<option value="Lejlighed">Lejlighed</option>
<option value="Landejendom">Landejendom</option>
<option value="Ejerlejlighed">Ejerlejlighed</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" height="5"></td>
</tr>
<tr>
<td></td>
<td class="twkst">Kontantpris:</td>
</tr>
<tr>
<td></td>
<td>
<select name="Pris" class="border">
<option>0</option>
<option value="250000 - 500000">250000 - 500000</option>
<option value="500000 - 1000000">500000 - 1000000</option>
<option value="1000000 - 1500000">1000000 - 1500000</option>
<option value="1500000 - 2000000">1500000 - 2000000</option>
<option value="2000000 - 3000000">2000000 - 3000000</option>
<option value="3000000 -">3000000 -</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" height="5"></td>
</tr>
<tr>
<td></td>
<td><a onFocus="this.blur()" href="#"><img src="BILLEDER/soeg.gif" border="0"></a></td>
</tr>
<tr>
<td colspan="2" height="3"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="150" valign="top" bgcolor="#EEEEEE" height="10"></td>
</tr>
<tr>
<td width="150" valign="top" bgcolor="#EEEEEE">
<table width="140" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#999999">
<tr>
<td valign="top" bgcolor="#CCCCCC" class="twkst">
<div align="center">NYHEDSBREV</div>
</td>
</tr>
<tr>
<td valign="top">
<Form name="nyhed" style="margin:2px;">
<table width="140" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2" ></td>
</tr>
<tr>
<td width="5" ></td>
<td class="twkst">Modtag nyhedsbrev:</td>
</tr>
<tr>
<td> </td>
<td>
<INPUT size=12 value="Din e-mail" name="Nyhedsbrev" class="border">
</td>
</tr>
<tr>
<td colspan="2" height="2"></td>
</tr>
<tr>
<td></td>
<td>
<div align="left"><a onFocus="this.blur()" href="#"><img src="BILLEDER/tilmeld.gif" width="37" height="12" border="0"></a>
<a onFocus="this.blur()" href="#"><img src="BILLEDER/frameld.gif" width="41" height="12" border="0"></a></div>
</td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
</table>
</Form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#EEEEEE" height="10"></td>
</tr>
<tr>
<td valign="top" bgcolor="#EEEEEE">
<table width="140" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#999999">
<tr>
<td valign="top" bgcolor="#CCCCCC" class="twkst">
<div align="center">ADMINLOGIN</div>
</td>
</tr>
<tr>
<td valign="top">
<Form name="adminlogin" action="" style="margin:2px;">
<table width="140" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5" colspan="2" ></td>
</tr>
<tr>
<td width="5" ></td>
<td class="twkst">Brugernavn:</td>
</tr>
<tr>
<td rowspan="4"></td>
<td>
<input size=12 value="" name="Login" class="border">
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<tr>
<td class="twkst">Adgangskode:</td>
</tr>
<tr>
<td>
<input size=12 value="" name="kode" class="border" type="password">
</td>
</tr>
<tr>
<td colspan="2" height="5"></td>
</tr>
<tr>
<td></td>
<td>
<div align="left"><a onFocus="this.blur()" href="#"><img src="BILLEDER/tilmeld.gif" width="37" height="12" border="0"></a>
</div>
</td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
</table>
</Form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#EEEEEE"> </td>
</tr>
</table>
</td>
</tr>
</table>
<%
wend
objRec.close
cn.close
set objRec = nothing
set cn = nothing
%>
</body>
</html>
