N
None
I'm using Windows 2000 Server IIS ASP and I'm attempting to display a
picture via an vbscript/ASP of a Blob image in SQL Server 2005. Below,
is part of the code (the important part) that I'm using after reading
up a bit. Unfortunately, I'm not getting the Blob image in one of our
Vendor's SQL database to pop up. Instead, I'm getting a box with a
red X in the middle of it
Any ideas?
SQL1 = "SELECT RD.ID, RD.image"
SQL1 = SQL1 & " WHERE RD.ID = '29'"
set rs = my_conn.Execute(SQL1)
<TR>
<TD bgcolor=<%=FieldColor%> align=center
colspan=1><B>ID</B></TD>
<TD bgcolor=<%=FieldColor%> align=center
colspan=1><B>Picture/B></TD>
</TR>
<%if rs.EOF then%>
<TR>
<TD bgcolor=<%=InfoField%> align=center
colspan=10><B>No definition found</B></TD>
</TR>
<%
else
do until rs.EOF%>
<TR>
<TD bgcolor=<%=InfoField%>
align=center><%=rs("ID")%> </TD>
<TD bgcolor=<%=InfoField%> align=center><img
src="<%=rs("image")%>"> </TD>
picture via an vbscript/ASP of a Blob image in SQL Server 2005. Below,
is part of the code (the important part) that I'm using after reading
up a bit. Unfortunately, I'm not getting the Blob image in one of our
Vendor's SQL database to pop up. Instead, I'm getting a box with a
red X in the middle of it
Any ideas?
SQL1 = "SELECT RD.ID, RD.image"
SQL1 = SQL1 & " WHERE RD.ID = '29'"
set rs = my_conn.Execute(SQL1)
<TR>
<TD bgcolor=<%=FieldColor%> align=center
colspan=1><B>ID</B></TD>
<TD bgcolor=<%=FieldColor%> align=center
colspan=1><B>Picture/B></TD>
</TR>
<%if rs.EOF then%>
<TR>
<TD bgcolor=<%=InfoField%> align=center
colspan=10><B>No definition found</B></TD>
</TR>
<%
else
do until rs.EOF%>
<TR>
<TD bgcolor=<%=InfoField%>
align=center><%=rs("ID")%> </TD>
<TD bgcolor=<%=InfoField%> align=center><img
src="<%=rs("image")%>"> </TD>