i have this code (i've already opened the database connection) and i am getting a "loop without do" error. does anybody see what i'm doing wrong?

<%

rs.movefirst
do while not rs.eof
if rs("itemNumber") = "112233" and rs("paymentStatus") = "Completed" then


%>

<td colspan="1" class="description" width="60" height="25" valign="top"><p>Item sold</p></td>
<td class="description" width="160" height="25" valign="top"></td>


<%

rs.movenext
loop

else

%>

<td colspan="1" class="payButtons" width="60" height="25" valign="top">
      <form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
        <input type="hidden" name="cmd" value="_cart">
        <input type="hidden" name="business" value="[email protected]">
        <input type="hidden" name="item_name" value="Dragon">
        <input type="hidden" name="item_number" value="112233">
        <input type="hidden" name="amount" value=".01">
        <input type="hidden" name="return" value="http://www.scrapmenagerie.com/somefolder/somefile.asp">
        <input type="hidden" name="cancel_return" value="http://www.scrapmenagerie.com/sorry.asp">
        <input type="hidden" name="no_note" value="1">
        <input type="hidden" name="currency_code" value="USD">
        <input type="image" src="http://www.scrapmenagerie.com/pageImages/buyButton.gif" border="0" align="left" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
        <input type="hidden" name="add" value="1">
      </form>
    </td>
    <td class="payButtons" width="160" height="25" valign="top">
      <form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post">
        <input type="hidden" name="cmd" value="_cart">
        <input type="hidden" name="business" value="[email protected]">
        <input type="image" src="http://www.scrapmenagerie.com/pageImages/viewCartButton.gif" border="0" align="left" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
        <input type="hidden" name="display" value="1">
      </form>
    </td>
<%

end if

%>

you either need to put the entire IF..THEN statement inside the LOOP, or put the LOOP entirely inside the IF..Then.

You have the DO..LOOP started,
the IF..THEN started
The DO..LOOP ended,
an ELSE
then an END IF


Chris

thank you. isn't my loop already inside my if then statement? would you mind giving me the specific example to fix my code? i appreciate the response.

sorry. asked to quickly. fixed the problem. thanks again...