<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2406&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
I've created a simple Photo Gallery that consist of 2 tables. Photogallery and Photos. (Photogallery as the master and photos as the child table.)
Everything works except when I "view" the photos, the "description" does not display. (Photos_view.asp)
Database = MS SQL Server
The 'photosdescription' is set (at the database level as "text" and in AspProrunner 4, as Rich Text and display as HTML.)
In the Photos_view.Asp the descrption field is formatted like the following;
<%
Response.Write "<tr><td width=165></td><td width=200 class=shade>" & Label(rs.Fields("photodescription").Name) & "</td>"
%>
<TD>
<%
if IsBinaryField(rs.Fields("photodescription")) or Format("photodescription")=FORMAT_DATABASE_FILE then
Response.Write CreateImageControl(rs, "photodescription", "")
else
strData = GetData(rs.Fields("photodescription"), "HTML")
Response.Write strData
end if
%>
</td>
What am I doing wrong?
Thanks for your help.