i've pulled data into a recordset. now i have a loop that loops through the recordset. if it finds a particular value, it should show a table with some data. if it doesn't find this value it shows another table with some images. here is my code for one section (this section is repeated 4 times).

my problem is that BOTH pieces of my code show up. they can't both be true. what am i doing wrong? thanks.

<%


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 sold2233</p></td>
<td class="description" width="160" height="25" valign="top"></td>


<%


elseif rs("itemNumber") <> "112233" then


%>



<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/asp/ipn.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 2233!">
        <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>


<%


else
end if
rs.movenext
loop


%>

Your code looks fine.
As all of your output is hard coded can you double check that you do not have two records in the recordset with different "itemNumber" or "Completed" values.
That is one way that both branches of your if else can be run.
If more than one record is expected how do you tell them apart in HTML?
The output will be the same as it is hard coded.

thanks for the reply. i should always have more than 1 record in the database. the itemNumber will always be different but paymentStatus will always be "Completed". i'm not sure what you mean if there are more than 2 values i won't be able to tell them apart in html. i want 1 html code to show if it finds the value (among many) and another html code to show if it doesn't find that value. i have to look for this particular itemNumber to determine which code i should display. am i going about this the wrong way?

btw... this is the page results when there are just 2 records in the database. the paymentStatus for both is "Completed" and the item number sare different, 112233 and 114455. http://www.scrapmenagerie.com/dragons.asp

as you can see, both parts of the code are showing. why does the other piece show (the buttons) when my code tells it to show only when itemNumber DOES NOT equal this value?

When I viewed that page it apeared to be ok. the first record only had the buttons, and the rest had sold and there item number.
Maybe you page has cached on your browser or something.
Or am I still missing the point?I'll send you a pic of you page as I see it.

Rod

thanks. i've moved past this code and i'm now using the code under the "values" post. i'm still having some problems though...