I am sorry about posting such an elementary question, but I just can't
get this to work:
<%if (Recordset1.Fields.Item("notes").Value)="" then%>
<%else%>
<tr><td>Additional notes:
<b><%=(Recordset1.Fields.Item("notes").Value)%></b></td> </tr>
<%end if %>
I just want to say if recordset "notes" is empty, don't do anything.
If it is not, then write <tr><td>Additional notes:
<b><%=(Recordset1.Fields.Item("notes").Value)%></b></td> </tr>
However, the words "Additional notes:" keeps showing up on every page,
regardless of whether "notes" is empty or not.
What am I doing wrong?
thanks in advance, crispy