Article View: adobe.acrobat.reader
Article #11756Re: Blobs of PDF data (how to I display in Browser)?
From: caroline susner
Date: Tue, 18 Jun 2002 21:34
Date: Tue, 18 Jun 2002 21:34
34 lines
1353 bytes
1353 bytes
I believe this is what you need to do:
Response.Buffer = True
Response.ContentType = "application/pdf"
Dim strSQL
Dim rs
Dim somenumber
Dim file
Call DatabaseConnect
somenumber = Request.QueryString("strFileID")
strSQL = "SELECT fieldname FROM sqltable "
strSQL = strSQL & "WHERE id = '" somenumber "'"
Set rs = objConn.Execute(strSQL)
file = rs("fieldname")
Response.BinaryWrite file
Response.End
rs.close
Set rs = Nothing
Call DatabaseDisconnect
%>
Hope this works for you
Technical Details
Message-ID:
<ef8d224.0@WebX.aaQKaf7vad4>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-03!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!feed2.news.rcn.net!rcn!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!WebXReferences:
<ef8d224.-1@WebX.aaQKaf7vad4>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 109513,fe82b602cae398cf X-Google-Attributes: gid109513,public X-Google-ArrivalTime: 2002-06-18 14:42:06 PST From: "caroline susner" <c@c.om> Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-03!supernews.com!yellow.newsread.com!netaxs.com!newsread.com!feed2.news.rcn.net!rcn!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!WebX Newsgroups: adobe.acrobat.reader Subject: Re: Blobs of PDF data (how to I display in Browser)? Message-ID: <ef8d224.0@WebX.aaQKaf7vad4> Date: Tue, 18 Jun 2002 14:34:56 -0700 References: <ef8d224.-1@WebX.aaQKaf7vad4> Lines: 33 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit