I am trying to format rows in a table based on a value of one of the fields. It's a table that shows emails, and I'd like to bold or make new emails stand out. I have a field called 'read_yet' that stores Y or N for new or old messages. My code is in a repeating region since I have to show multiple rows, and I can't seem to make this work with simple code like below, or with CSS formatting.

<% if rsEmail("read_yet" = "N" then %>
<b><%= rsEmail("message" %><b />
<% else %>
<%= rsEmail("message" %>
<% end if %>

Anyone run into this or have any ideas?

I figured it out...

my database YN is stored as a bit (1,0), and that is supposed to be coded as "True" or "False" in ASP, not 0 or 1.