bing-bonger

Guys,Gals!!!

I am creating a website using ASP and Ms Access for an on-line portfolio (over 200 images divided into 10 sub sections), what I would like to know is how do I populate a database table in Access with jpegs, and how do I get them to display within the HTML, is it the same process and displaying text from a database????

Any help would be very very much appreciated....


thanks

ids

Heheheheh..... been there too.

2 options - either convert/encode the image and then store in a MEMO feild - however there is some limitations on this in Access or better still store the image within the file system and store the link/url for display.

I do have some more info on Option 1 but not to hand....

Ids

chiark

Store 'em in a memo field, then retrieve using ASP.

Your img src will look strange, as you'll call an asp page to retrieve them (such as <IMG SRC=image.asp?name=test.jpg> ) but on the other hand it'll work.

Your asp wants to set its response type:
Response.Buffer = TRUE
Response.ContentType = "image/jpeg"

You then want to find your image in your recordset that you've opened (assume you know how to do this).

Write your image out using
response.binaryWrite myRS("Image").GetChunk(myRS("Image").ActualSize

Where myRS is your Recordset object, "image" is the field name containing the image.

Finally, end the response with
response.end

Doing this means that you can also control access to your graphics, such as to ensure people are logged on before seeing the graphics, and also that no other site is leeching graphics off your server.

Cheers,

Nick.

bing-bonger

Or maybe i should just you sql-server as that has an option for image???


What do you guys think??