Solved

Can I use ASP to write a image?

Posted on 1998-09-19
4
205 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 200 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now