I have an access database with lots of fields including a memo field called
'priecinfo'.
Everything works well, lots of data is written, but in one particular
situation, I can't get the field 'priceinfo' to write out:
1) the code below works properly except that the field 'priceinfo' doesn't
get written - replace it with any other field and it works.
If Recordset1("priceinfo") <> "" Then
Response.Write("<tr><td colspan='2' class='subhead'>PRICE AND BOOKING
INFORMATION</td></tr> <tr>")
Response.Write("<td colspan='2' class='subcont'><p class='pricing'>")
Response.Write (Recordset1("priceinfo")) '
(this line doesn't execute - the rest does)
Response.Write("</p></td> </tr>")
End If
Where there is information, the html gets written, but the record doesn't so
the 'If Then' statement is testing the record properly.
2) Write it like this and it does work this does work
<tr><td colspan='2' class='subhead'>PRICE AND BOOKING INFORMATION</td></tr>
<tr><td colspan='2' class='subcont'><p class='pricing'>
<% Response.Write (Recordset1("priceinfo")) %>
</p></td></tr>
3) Put the If Then back in and it doesn't work again
<tr><td colspan='2' class='subhead'>PRICE AND BOOKING INFORMATION</td></tr>
<tr><td colspan='2' class='subcont'><p class='pricing'>
<%
If Recordset1("priceinfo") <> "" Then
Response.Write (Recordset1("priceinfo"))
End If
%>
</p></td></tr>
I can get round it but I am intregued to know if anyone can shed light on
this.
TIA
John