🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.acrobat.reader
Article #11756

Re: Blobs of PDF data (how to I display in Browser)?

#11756
From: caroline susner
Date: Tue, 18 Jun 2002 21:34
34 lines
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!WebX
References: <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