BLOB_JSCRIPT.ASP

<% @ LANGUAGE=JScript%> 

<!--#include file="adojavas.inc"-->

<%
// This sample utilizes the Image field in the PUB_INFO table.
// This table is installed with Microsoft SQL Server in
// the PUBS database.


var oConn;
var oRs;
var Pic;
var PicSize;


// Setup HTTP Header Information so that the browser interprets
// the returned data as a gif graphic file. Note that browsers
// interpret returned information using MIME headers -- not file
// extensions.

Response.Buffer = true;
Response.ContentType = "image/gif";


// Create ADO Connection Object. Use IISSDK OBDC Souce with
// default sa account and no password

oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("DSN=LocalServer;UID=sa;PWD=;DATABASE=pubs");


// Query SQL to obtain recordset containing gif BLOB

oRs = oConn.Execute("SELECT logo FROM pub_info WHERE pub_id='0736'");


// Obtain local variable of GIF

PicSize = oRs("logo").ActualSize;
Pic = oRs("logo").GetChunk(PicSize);


// Write Data back to client. Because MIME type is set to
// image/gif, the browser will automatically render as picture

Response.BinaryWrite(Pic);
Response.End();
%>