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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.