reading and displaying bitmap blob fields from oracle!!!

[davejam]

another question that has stumped me for the last couple of weeks on and off!!!

hi all,

i am just struggling with pulling bitmap images into asp pages from an oracle database!!!

i have created a file that reads the field in and then reference that field in my asp page within an img!!!

i'm using the following code to pull the image into an asp page

<%@ LANGUAGE="VBSCRIPT" %>
   <%
   ' Clear out the existing HTTP header information
   vThreadOID=207098
   Response.Expires = 0
   Response.Buffer = TRUE
   Response.Clear
 
  ' Change the HTTP header to reflect that an image is being passed.
   Response.ContentType = "image/bitmap"
 
   sSql = "SELECT CAPTURE.SIGNATURE "
   sSql = sSql & "FROM CAPTURE "
   sSql = sSql & "WHERE CAPTURE.THREADOID=" & vThreadOID
   set objRs = oCon.execute(sSql)
 
   Response.BinaryWrite objRs("SIGNATURE")
   Response.End
   %>

then i'm trying to call the picture into my report page using the following

<img src='getSig.asp'>

but it seems to pull in the right size for the image (allocated blank area oon the page) but just pulls in a small section from the bottom left hand side... about 2 pix high and half the image wide!!!

do i need to set some kind of size or is there a better way to do it??

Thankyou

daveJam

even my shrink says its all your f#@/ing fault