[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can I use ASP to write a image?

Posted on 1998-09-19
4
Medium Priority
?
219 Views
Last Modified: 2013-12-25
I used a lot response.write to write text into HTML file. Can I and how can I write a image into the html file. I found that there is a function named response.binarywrite, but don't know how to use it? I would be very appretiate if anybody could give me an advice.
0
Comment
Question by:yysun
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 400 total points
ID: 1855158
You can do more or less what you want, but it's probably different from what you think.

In HTML the code for an image is made by a <img src="image.gif">

What you can do is use: <img src="ShowImage.asp?ID=5">. To do this you need a ShowImage.asp, which sends the binary data of an image.

Example code of ShowImage.asp:
================
<%
Response.ContentType = "image/GIF"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=Images"

strSQL = "SELECT * FROM Images WHERE ID=" & Request.Querystring("ID")
Set RSImage = Conn.Execute(strSQL)

Response.Binarywrite RSImage("Image")

%>
========================
Which will show an image that is stored in a database.


Another example:
=========================
<%
Response.ContentType = "image/GIF"
%>
<!--#INCLUDE FILE="image.gif"-->
========================
Which will read aa image file from the server

0
 

Author Comment

by:yysun
ID: 1855159
Thank you sybe.

In the first Example, can you tell me what is DBMS and what is the filed type of "image"?

Can I first write some text then an image, e.g. Add
Response.write "hello"
before
Response.ContentType = "image/GIF"

finally, how can I develop an OLE Automation server to create the image?

0
 
LVL 28

Expert Comment

by:sybe
ID: 1855160
1. I don't know what you mean by DBMS, I know it only from a property of the connection object, and it tells you what kind of database is in use.

2. The file type of the image does not really matter. Browsers will display a JPG ok, even if it is told that it's a GIF.

3. No, when you add any code before "Response.ContentType = .." then you get an error message.
If you write some output after ContentType = image/GIF, then the browser thinks that that text is part of the binary code of the image, and the browser is not able to display the image well (it shows a broken image).

4. You should NOT read the images into the database using OLE, even if you use a OLE-filed type. If you use OLE to get the image into the database, ACCESS will convert it to BMP and at the same time save the original format. So this will really destroy the binary code you want to have.
What you need is to use the AppendChunk function of VBA to read the image into the OLE-field as binary code.



0
 

Author Comment

by:yysun
ID: 1855161
I mean what type of database to use, SQL server or access or anything else.

And what is the FIELD type for the image data? (sorry for previous wrong type filed type)?

Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to count occurrences of each item in an array.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses
Course of the Month18 days, 19 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question