This sample demonstrates how to display multiple images from a table in a
database. I had a table in my SQL Server database named "TestImage",
which contained 2 fields "ImageID (auto number)" and "Image( Image)".
I created 2 files, loadimage.asp and showimages.asp
LoadImage.asp
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select image from advertisements where ad_id='"& request.QueryString("ad_id")&"'",conn1
if not rs.eof then
response.BinaryWrite rs("image")
end if
rs.close
set rs=nothing
%>
ShowImages.asp
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select ad_id,image from advertisements",conn1,1,2
if not rs.eof then
do while not rs.eof
If not isnull(rs("image").Value) Then
%>
<img src="loadimage.asp?ad_id=<%=rs("ad_id")%>">
<%
end if
rs.movenext
loop
end if
rs.close
set rs=nothing
%>