If statement when retrieving variable from database

[Meditrina]

I have code that looks like this (pulling in 3 fields from a sql database), but I want it to only show the fields if <%=rs("UnitPrice3")%> is greater than 0. How do I write the if statement on my asp page?

<div class="orderItem">
<a href="http://www.xyz.com/eshop/shop.asp?productcode=<%=rs("ProductCode3")%>" title="Order"><img src="http://bytes.com/images/order.gif" alt="Order" /></a>
                   <span>$<%=rs("UnitPrice3")%></span>
                   <%=rs("ProductName3")%>
</div>
 

I've attached an image of what I get without the IF statement - I don't want to see the order button or the $ if the unit price is <0.

Thanks for any help.

[jhardman]

<div class="orderItem">
<%
if rs("unitprice3") > 0 then %>
   <a href="http://www.xyz.com/eshop/shop.asp?productcode=<%=rs("ProductCode3")%>" title="Order"><img src="http://bytes.com/images/order.gif" alt="Order" /></a>
                      <span>$<%=rs("UnitPrice3")%></span>
<%
end if %>
                   <%=rs("ProductName3")%>
</div>
 

Is this what you are looking for?

Jared

[Meditrina]

Yes - thank you! That worked.