Find i alle poster

while not rs.eof
  ...noget...
  <%if rs1("plads") = "B1" then%>Optaget<%else%>ledig<%end if%>
  <%if rs1("plads") = "A3" then%>Optaget<%else%>ledig<%end if%>
  <%if rs1("plads") = "A2" then%>Optaget<%else%>ledig<%end if%>

  rs.movenext
wend

Jeg ved ikke om jeg har forstået din problemstilling korrekt, men det lyder som om du har brug for et JOIN mellem arrangement- og tilmeldinger-tabellerne...

SELECT * FROM arrangement INNER JOIN tilmeldinger ON arrangement.id = tilmeldinger.arrangement

Dette skulle gerne give dig et resultat hvor alle tilmeldinger er koblet med det arrangement som det nu er knyttet til. Men var det det du ville have?

Sender lige min kode så i kan se hvad det er jeg mener.


<% if s = "Lan" then
Set rs = Conn.Execute("select * from Arrangement where id = " & request("id") & " ")
Set rs1 = Conn.Execute("select * from Tilmeldinger where Arrangement = " & rs("id") & " ")
%>

<br><br>

<table border="0" cellpadding="0" cellspacing="0" id="table1">
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" colspan="2" style="font-family: verdana">
        <p align="center"><font size="1"><%if rs1("plads") = "B1" then%><img src="<%=rs1("computer")%>.gif"><br><b><%=rs1("navn")%></b><br><%=rs1("mail")%><%else%>ledig<%end if %></font></td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="250" height="150" style="font-family: verdana" colspan="3" rowspan="3">
        <p align="center">
        <font size="5"><b><%=rs("Overskrift")%></b><br><%=rs("Dato")%></font><br><font size="2"><%=rs("tekst")%>
        </td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" bgcolor="#C0C0C0" colspan="2" style="font-family: verdana; border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000">
        <p align="center"><b>B1</b></td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" style="font-family: verdana">
        <font size="1">
        <p align="center"><%if rs1("plads") = "B2" then%>optaget<%else%>ledig<%end if %></font></td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; padding-left: 1px">
        <b>B2</b></td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-right: 1px solid #000000">
        <b>B6</b></td>
        <td width="100" height="50" style="font-family: verdana">
        <font size="1">&nbsp; X<img border="0" src="PC.gif" width="24"></font></td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">&nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; padding-left: 1px">&nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-right: 1px solid #000000">&nbsp;</td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="50" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="100" rowspan="2" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="50" height="100" bgcolor="#C0C0C0" rowspan="2" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; padding-left: 1px">
        <p align="center"><b>B3</b></td>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-right: 1px solid #000000">&nbsp;</td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-top: 1px solid #000000"><b>A6</b></td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-top: 1px solid #000000"><b>A5</b></td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-right: 1px solid #000000; border-top: 1px solid #000000"><b>A4</b></td>
        <td width="50" height="100" style="font-family: verdana" rowspan="2">&nbsp;</td>
        <td width="100" height="100" style="font-family: verdana" rowspan="2">&nbsp;</td>
    </tr>
    <tr>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-right: 1px solid #000000">&nbsp;</td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-bottom: 1px solid #000000"><b>A3</b></td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-bottom: 1px solid #000000"><b>A2</b></td>
        <td width="100" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-right: 1px solid #000000; border-bottom: 1px solid #000000"><b>A1</b></td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">&nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; padding-left: 1px">&nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" style="font-family: verdana; border-right: 1px solid #000000">&nbsp;</td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="50" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">
        <font size="1">X</font></td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; padding-left: 1px"><b>B5</b></td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" style="font-family: verdana; border-right: 1px solid #000000; "><b>B4</b></td>
        <td width="100" height="50" style="font-family: verdana">
        <font size="1">&nbsp; X</font></td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="50" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana" valign="top">
        &nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" valign="top" style="font-family: verdana; border-left: 1px solid #000000; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #000000; padding-left: 1px">&nbsp;</td>
        <td width="50" height="50" bgcolor="#C0C0C0" align="center" valign="top" style="font-family: verdana; border-right: 1px solid #000000; border-bottom: 1px solid #000000">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana" valign="top">
        &nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="50" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
    <tr>
        <td width="100" height="50" align="center" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" colspan="2" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="50" height="50" style="font-family: verdana">&nbsp;</td>
        <td width="100" height="50" style="font-family: verdana">&nbsp;</td>
    </tr>
</table>

<p>
<%
rs.close
set rs= Nothing

rs1.close
set rs1= Nothing
end if %>

Hvis jeg forstår din opgave korrekt, så skal du udfylde pladserne på en bordplan. I dette tilfælde kan det være lidt svært at benytte en simpel løkkekonstruktion. Jeg tror det letteste umiddelbart ville være at udføre en rs.MoveNext hver gang du har checket om en plads er ledig eller optaget. Dette gøres indtil alle pladser er checket. Denne metode er naturligvis kun "interessant", hvis du altid har samme bordplan/bordlayout (under antagelse af at det er den bordplan :o)). Er der tale om forskellige layouts, så skal du nok ikke regne med denne metode... med mindre du er nød til at lave en ny asp-fil for hvert layout...

Kan du evt. uddybe dine behov yderligere, hvis dette ikke er hvad du søger?

softspot:
Jeg har samme bordplan hele tiden. Så den måde ville jo nok være løsningen. Har selv prøvet med syntes ikke at kunne få det til at fungere.
Hvordan ville du stille det op?

lukker