vbscript read binary data from sql server

Jak

908 Points

132 Posts

Hi,

How read binary data from sql server in vbscript ?

Views: 9130
Total Answered: 1
Total Marked As Answer: 1
Posted On: 09-Mar-2015 12:20

Share:

Answers

NiceOne...

1390 Points

18 Posts

Hi, Rahul

You can use <IMG> tag to display images stored in the database by calling another ASP page in SRC attribute of <IMG> tag.

For example:

where PhotoId is the ID stored in the database.

ShowPicture.asp:

PhotoId=request.QueryString("PhotoId")

ImageQuery="select Image From ImageTable where PhotoId='"&PhotoId&"'"

set rs=server.CreateObject("ADODB.recordset")

rs.open ImageQuery,conn,3,1

Response.Clear()

Response.ContentType="Image/jpeg"

Response.BinaryWrite rs("Image")

Response.End()

Posted On: 11-Mar-2015 22:08

Discussion

MVC Design pattern