Hello Techies. I have a ASP 101 question. I need to know

[Kahuna]

how to suppress a row with no data.

I have 19 rows as follows for ingredients 1 through 19.

<% IF RS( "Ingredient9" ) <> "?????" THEN %>
<%=RS( "Ingredient9" )%>
<% END IF %>

How do I suppress rows with "?????" so that if Ingredient5 through ingredient19 have "?????", empty row spaces are not created? Or, a big gap is not created after row Ingredient5 and the next line of code that would come after Ingredient19?

I know this is really simple, but I just picked up ASP less than a month ago, and I need a solution to this problem, as soon as possible. So, if any of you techies will send me a PM with the solution, I'd really appreciate it.

[EvolveOrConvolve]

1. I've done a lot of ASP.NET (which is entirely different)

Vanilla ASP is vb script and I know a lot of VB, so try this: (I've bolded the parts that I've added)

<% IF CString(RS.Fields( "Ingredient9" ).Value) <> "?????" THEN %>
<%=RS( "Ingredient9" )%>
<% END IF %>

I'm not sure if the CString method works in VB script, but it's worth a try.