Hi,
I have a few thousand images stored in BLOB fields on our MS SQL server and I would like to display these in a web page. The site I have written is in ASP and Javascript which pulls standard recordsets from the DB, I just want to add the option to view these pictures.
Thanks
Seb
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
To display image in web page you have to:
Select image content from BLOB:
1. Select column_with_image_blob from table where ...
Create a page with proper content type for example (if image is jpg):
Header ("Content-type: image/jpeg");
and then to print image content in page:
print base64_encode($image);
I am not sure what is the right syntaxix in asp but the steps are these
Thanks for that guys - I've followed the steps show by MS with a few tweaks but it's not quite working.
Have I messed something up in the code or is there a permission kind of issue going on - the page loads up
but I get a blank image place holder instead of the image.
<%@ LANGUAGE="VBSCRIPT" %>
<%
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
'Declare Variables..
Dim sql
Dim rs
Dim conn
Dim userID,str
userID = Request("id")
If userID = "" Then userID = 0
'Instantiate Objects
Set conn = Server.CreateObject("ADODB
Set rs = Server.CreateObject("ADODB
'Open connection
conn.Open "DSN=DocArchiveDB_Comp1;UI
'Get the specific image based on the ID passed in a querystring
str = "SELECT data FROM dms_document where id =" & userID
rs.Open str, conn,3,3
if rs.eof then 'No records found
Response.End
else 'Display the contents
Response.ContentType = "image/jpg"
Response.BinaryWrite(rs("d
Response.End
end if
'destroy the variables.
rs.Close
conn.Close
set rs = Nothing
set conn = Nothing
%>
Hmm - are you sure the data isnt corrupt or anything? Have you tried using several different images?
Did you try embedding in a HTML page too using the extra code?
<HTML>
<HEAD><TITLE>Display Image</TITLE></HEAD>
<BODY>
This page will display the image New Moon Books from a SQL Server
image field.<BR>
<IMG SRC="SHOWIMG.ASP">
</BODY>
</HTML>
Business Accounts
Answer for Membership
by: jkdt0077Posted on 2009-06-12 at 02:27:27ID: 24610458
http://support.microsoft.c
Have a look at that, it should be exactly what you need!