PTS. til ortrak
Lige et lille ? mens jeg har dig på tråden....<%
Dim Connect1, rl, Query1, Emne
link = Trim(Request("link"))
if link = "?" then
link ="Interne-links"
end if
Emne = Trim(Request("Emne"))
Set Connect1 = Server.CreateObject("ADODB.Connection")
Connect1.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("DATABASE") & ";Default\;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5"
Query1 = "SELECT * FROM DATABASE WHERE Kategori='" & link & "' ORDER BY Emne"
Set rl = Connect1.Execute(Query1)
%>
<table border="0" width="165" cellspacing="0" cellpadding="0" height="91">
<tr>
<td width="10" height="42"></td>
<td width="316" height="42"><b><font color="#FFFFFF"> </font></b></td>
</tr>
<tr>
<td width="10" bgcolor="#000080" height="25"> </td>
<td width="316" bgcolor="#000080" height="25" valign="middle"><b><font color="#FFFF00" face="Arial" size="3">Relateret
Links:</font></b></td>
</tr>
<tr>
<td width="10" height="3" valign="middle" align="left" bgcolor="#FFFFFF" style="border-left: 2 solid #000080; border-bottom: 2 solid #000080"><font color="#000080"> </font></td>
<td width="316" height="3" valign="middle" align="left" bgcolor="#FFFFFF" style="border-right: 2 solid #000080; border-bottom: 2 solid #000080"><b>
<font color="#000080">
<%for i = 1 to 5
if i > 5 then
end if
Randomize(????????)
%>
</font><a href="<%=rl("Url")%>" target="_blank"><font color="#000080"><%=rl("Emne")%><br>
<%
rl.MoveNext
next
%>
Hvordan får jeg den til at vælge en tilfældig (random) og rette fejlen med at der skal være 5 links ellers får jeg fejl...
/Oscar
