Retriving images from database

[mcp87]

Hey all I need some help with displaying some images that are in a database. Currently when I try to display them they come out in binary form and I am stumped on how to correct it.

Server info:

WWW Server:
Windows Server 2003
ASP .Net
Pages are .aspx written in VBScript

Database Info:
MS SQL Server 2000

Problem code:

<%
Dim rs
rs = Server.CreateObject("adodb.recordset")
rs.Open("Select * From avatar", Application("Conn"))
If not rs.eof then
Do Until rs.eof
Response.ContentType = "image/gif"
Response.binarywrite(rs.fields("a_avatar").value)
rs.movenext
Loop
rs.close
End If
%>

As stated above the result is display of the three images in the database in binary form.
http://test.adiktclan.com/test.aspx

Any help is greatly appreciated.

Thanks,

John K
MCSA, A+

[Danial]

Have you seen the suggestion I made here http://www.vbforums.com/showthread.p...tpost&t=321793

Its best not to cross post in 2 forums, most of us visit DB & ASP forums.

[mcp87]

I have tried setting the page up that way but it produces the same that i am already getting witch is like 20 pages of binary with small littel image boxes at the start of each each image

[Danial]

I have tried setting the page up that way but it produces the same that i am already getting witch is like 20 pages of binary with small littel image boxes at the start of each each image

What did you define the field type as?

[mcp87]

I am asuming you are refering the field in the database, that field is defined as image

Please post future responses on topic in database section

http://vbforums.com/showthread.php?t=321793