Thank You

Your code works well. However it could be of help to some to add <img source="file.asp?ID=<%=(rs("ID"))%>"> for those for those who want to display the image directly in to their asp/html page.

Regards
Julio

Julio,

Yes it is possible and you've already given an example. Does it not work for you?

Hi!
This is what i started with
If Not rsPrints.EOF Then
Response.Write "<table border = '1'>"
While Not rsPrints.EOF
Response.Write "<tr>"
Response.Write "<td><img src = '../"
Response.Write rsPrints("File")
Response.Write "' width = '130' height = '170'></td>"
Response.Write "</tr>"
rsPrints.MoveNext

Wend
Response.Write "</table>"
Else
Response.Write "No Items Found"
End If

of course, it displays 1 image a row.
How to write a code to display 4 images a row?

Thank you.
Gina

Hi Faisal

I have worked through your excellent tutorials on binary uploads.

However, I seem to be having a problem retrieving certain images from the database (Access).
These are where the content type is either image/pjpeg or image/jpeg. Why is this?
I am using IE6 browser.

Regards

Nigel

If your Recordset contains only the filename then

<%
dim rsPrints,sFile
set rsPrints=Server.CreateObject("ADODB.Recordset")
rsPrints.Open "SELECT FileName FROM tblName", Cnn
If Not rsPrints.EOF Then
%>
<table border = 1>
<% While Not rsPrints.EOF
sFile="../images/" & rsPrints.Fields(0) & ".GIF"
%>
<tr>
<td>
<img src =<%= sFile %>>
</td>
</tr>
<%
rsPrints.MoveNext
Wend

%>
</table>
<% End If %>

If your Recordset contains only the filename then

<%
dim rsPrints,sFile
set rsPrints=Server.CreateObject("ADODB.Recordset")
rsPrints.Open "SELECT FileName FROM tblName", Cnn
If Not rsPrints.EOF Then
%>
<table border = 1>
<% While Not rsPrints.EOF
sFile="../images/" & rsPrints.Fields(0) & ".GIF"
%>
<tr>
<td>
<img src =<%= sFile %>>
</td>
</tr>
<%
rsPrints.MoveNext
Wend

%>
</table>
<% End If %>

bdregmi@hotmail.com