5 pts.
 write multiple images from SQL database using response.binarywrite
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?

Software/Hardware used:
ASKED: August 10, 2008  10:48 PM
UPDATED: August 11, 2008  12:23 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _