I ran into this problem before.
I will try to make this as simple and understandable as I can.
If there is an easier way anyone knows, please let all of us know.
When I had to do it I used ASP. so I will keep going as if it is going to be developed in asp.
A regular asp page that has html tags on is of content type "text/html" ... Response.ContentType
When you retrieve an image from the database , you are actually recieving the encoded binary file. A regular response.write(recordset.Fields("ImageField")), will not do it.
To write the image for the browser to read the content type should be set to "image/jpeg" or "image/gif"
Now you cannot switch from content type text to content type image on the same page.
Work around:
Create a small asp page: Lets call it imageViewer.asp
Code:
Set rs = Server.CreateObject("ADODB.RecordSet")
Dim ID
ID = Trim ( Request("ID") & "")
Check on ID is valid ..... ID is the ID of the record that will have the image field.
Set rs = Database.Execute("SELECT * FROM tbl_Images ID = " & ID )
If NOT (rs.EOF AND rs.BOF) Then
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs("Image Field Name")
rs.Close
End If
Set rs = Nothing
Now from your regular asp page
the imag tag will look something like this
<IMG src = "images/ImageViewer.asp?ID=192837">
=======================
Another problem I have faced and this cost me alot of time.
"The binary code ACCESS will translate the image to" is different if the OLE object was imported "from inside ACCESS" than if it was "uploaded to the database using a webpage".
This only worked for me when the images where uploaded using an asp page.
I hope this is of any help, and please if you have any questions, just ask.
Dev Shed Forums Sponsor:
February 25th, 2003, 09:50 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
