Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: How to use Embeded Picture of Database?


Message #1 by "candy martin" <zeeshansabirsultan@y...> on Sun, 23 Feb 2003 15:39:22
Hi!
  I want to use a picture that is EMBEDED in a Database(MS Access 
Database). EMBEDED means that the picture is stored in a feild of type 
OLE, it should be kept in mind that it is a link to picture.
Now i m facing this problem that <IMG> is not supporting EMBEDED picture 
formate. Please tell me how to solve this problem.

Thanks.
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 24 Feb 2003 17:56:38 +1100
Your HTML page is just text. Your image is binary.
That is why in your page you have <img src="..path to image here...">
The browser then downloads the image separately.

So, you need to do something like:

<img src="/getImage.asp?ImageID=1">

and getImage.asp goes to your database and extracts the image from the
database. You then set the Response.ContentType to "image/gif" or
"image/jpeg" (or whatever format you are using), and then you
Response.BinaryWrite() the data to the client

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "candy martin" <zeeshansabirsultan@y...>
Subject: [access_asp] How to use Embeded Picture of Database?


: Hi!
:   I want to use a picture that is EMBEDED in a Database(MS Access
: Database). EMBEDED means that the picture is stored in a feild of type
: OLE, it should be kept in mind that it is a link to picture.
: Now i m facing this problem that <IMG> is not supporting EMBEDED picture
: formate. Please tell me how to solve this problem.
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


  Return to Index