1.11M Members

retrieve image from mssql using ASP

 
0
 

I cant load the image from database

please help..

strsql = "select top 1 id,shape from table"
set rsgetimage = server.CreateObject("adodb.recordset")
rsgetimage.open strsql,application("connectionstring")



   Response.Expires = 0
   Response.Buffer = TRUE
   Response.Clear

   Response.BinaryWrite(rsgetimage("shape"))
   Response.ContentType = "image/png"


rsgetimage.close

it just display an x icon


- thanks

 
0
 

1. you have written the image before specifying the contentType so asp is defaulting to text/html.

2. response.buffer and response.expires should appear first on your page with response.contentType

3. you have no code to handle empty results.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article