Displaying graphics and word documents from a database in a web page

[pozzie]

Hi

I'm having some difficulty in properly displaying some graphics and word documents in a web page i'm creating.

The images and word documents are stored in a database as OLE objects. I can extract these files from the database using standard SQL but I don't know how to display them (i.e. the images). What I want to do with the word documents is have them stored in links so that when a link is clicked on, the particular document is displayed.

If anyone has some tips or advice it would be greatly appreciated.

Thanks,
pozzie.

[Danial]

Originally posted by pozzie
Hi

I'm having some difficulty in properly displaying some graphics and word documents in a web page i'm creating.

The images and word documents are stored in a database as OLE objects. I can extract these files from the database using standard SQL but I don't know how to display them (i.e. the images). What I want to do with the word documents is have them stored in links so that when a link is clicked on, the particular document is displayed.

If anyone has some tips or advice it would be greatly appreciated.

Thanks,
pozzie.

Use BinaryWrite, here is a tutorial on how to retrive images stored in database. For Word file just change the content type, other then that it is the same.

Hope this helps.

Danial

http://www.4guysfromrolla.com/webtech/060100-1.shtml

[pozzie]

Hey Danial

Shot for the tut! I'm sure this is what I'm looking for! Will give it a bash. Sorry I'm replying so late - we were away over new year. Hope you had a good one!

Pozzie.

[mendhak]

It would be more efficient to store the URLs to the graphics instead of the OLE objects themselves. This way you only need to to

<img src="<% Response.Write objrs.Fields("urltographic") %>">

[pozzie]

Thanks for your input, Mendhak.

I am familiar with that way of rendering graphics but the only problem with that is that the users of the website need to update it themselves, online through a back end system i'm incorporating into the site. I assumed it would be easier for them to just save the images of the products they market to the database as these may constantly change.

regards,
pozzie.