retrieve image from mssql using ASP

[jcarbillon]

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

[vsmash]

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.