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

Printable View

Dec 29th, 2003, 09:10 AM
pozzie

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

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.
Jan 1st, 2004, 12:43 PM
Danial

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

Quote:

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
Jan 5th, 2004, 01:22 AM
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.
Jan 5th, 2004, 02:48 PM
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
VB Code:
```
<img src="<% Response.Write objrs.Fields("urltographic") %>">
```
Jan 6th, 2004, 01:13 AM
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.