write multiple images from SQL database using response.binarywrite

5 pts.
Tags:
Response.BinaryWrite
SQL
SQL Database
VBScript
It seems I am able to write a single image with the following code:
ID1 = replace(request("ID1"), "'", "''")

Dim connStr
	connStr = Application("DSNFPT")
Dim rs

	Set rs = Server.CreateObject("ADODB.Recordset")
	
	rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by id desc", connStr, 2, 4
	
	If Not rs.EOF Then
		Response.ContentType = rs("ContentType")
		Response.BinaryWrite rs("Image") & "here"
	else
		response.write "No Image Available"
	End If

	rs.Close
	Set rs = Nothing
However I need to write 2 images in the same page (they will actually overlap each other so I can't just create 2 img tags that call different pages). I also can't overlap the image myself and then upload it that way because I have thousands of combinations that the user can put together. Is this possible to do using binary.write or should I be looking for a different solution?
ASKED: August 10, 2008  10:48 PM
UPDATED: August 11, 2008  12:23 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following