title: Do Until Recordset.Eof is not working as expected (ASP Classic)
body: <p>I have an Active Server Page, which displays Booking of the current Day. </p>
  
  <p>With that Code i get the Informations from the DataBase:</p>
  
  <pre><code>Do Until Recordset.Eof
  
  
  
        rsRaum.open "select raum_id, KOPPELBESTUHLUNG_ID from RESERVIERUNGRAUM where buchung_id = " &amp; Recordset("buchung_id"), Connection
              raum_id = rsRaum("raum_id")
              KOPPELBESTUHLUNG_ID = rsRaum("KOPPELBESTUHLUNG_ID")
        rsRaum.close
  
  
        rsRaum.open  "SELECT NAME, FIRMA FROM TEILNEHMER WHERE BUCHUNG_ID =" &amp; Recordset("buchung_id") &amp; "and STATUS = 2 and DAILYPLAN = 1" , Connection
               if not rsRaum.EOF then
                      TeilnehmerNameExtern = rsRaum("NAME")
                      TeilnehmerFirmaExtern = rsRaum("FIRMA")
               end if
        rsRaum.close
  
  
  
  
        ' hole Raum Details
        rsRaum.open "select bezeichnung from Raum where ID = " &amp; raum_id, Connection
  
            raumname = rsRaum("bezeichnung")
  
        rsRaum.close
  
  
  
      Recordset.MoveNext
      Loop
  </code></pre>
  
  <p>So Far it works fine. My Only Problem is that part:</p>
  
  <pre><code>rsRaum.open  "SELECT NAME, FIRMA FROM TEILNEHMER WHERE BUCHUNG_ID =" &amp; Recordset("buchung_id") &amp; "and STATUS = 2 and DAILYPLAN = 1" , Connection
               if not rsRaum.EOF then
                      TeilnehmerNameExtern = rsRaum("NAME")
                      TeilnehmerFirmaExtern = rsRaum("FIRMA")
               end if
        rsRaum.close
  </code></pre>
  
  <p>My Problem: </p>
  
  <p>I have a Booking, to that Booking i assign three Participants (TEILNEHMER). But if i try to display the Participants, the ASP is only displaying one of that three Participants, which i assigned to that booking. </p>
  
  <p>What should i do to get all the Participants which are assigned to that booking? Do i have to loop also through that part of Code? I have tried but nothing worked.</p>
  
  <p>Can Someone help me?</p>
  
  <p>EDIT :</p>
  
  <pre><code>rsRaum.open  "SELECT NAME, FIRMA FROM TEILNEHMER WHERE BUCHUNG_ID =" &amp; Recordset("buchung_id") &amp; "and STATUS = 2 and DAILYPLAN = 1" , Connection
           if not rsRaum.EOF then
  
  
  
           do while not rsRaum.eof
  
  
                  TeilnehmerNameExtern = rsRaum("NAME")
                  TeilnehmerFirmaExtern = rsRaum("FIRMA")  
  
               rsRaum.movenext
  
            loop
  
           end if
    rsRaum.close
  </code></pre>