Great work Troy, Something to add, that I discovered the hard way, is that some versions of the Adobe Plug-in for PDF may not initialize properly because the plug-in needs to know the size of the document before hand.
So you might want to add "Content-Length:" to the HTTP Response header, something like: <@ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL> <@ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE="Content-type: application/pdf<@CRLF>Content-Length: <@LENGTH STR='<@COLUMN <@DQ>articles.art_blob<@DQ> ENCODING=NONE>'><@CRLF><@SETCOOKIES><@CRLF>"><@COLUMN "articles.art_blob" ENCODING=NONE> Of course it might be more efficent to capture the <@LENGTH> on the upload and store it a separate field next to the PDF content. Hope this helps. Cheers.... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- > -----Original Message----- > From: Troy Sosamon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 10:59 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > Here is the trickey part that you need. > Use a javascrip and open a new window and call a search > action that returns > a blob and use this code: > > <@EXCLUDE> > <@ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL> > <@ASSIGN NAME=HttpHeader SCOPE=LOCAL > VALUE="Content-type: application/pdf<@CRLF><@SETCOOKIES><@CRLF>"> > </@EXCLUDE><@COLUMN "articles.art_blob" ENCODING=NONE> > > > <@comment>other content types-- VALUE="Content-type: > image/jpeg, text/html > </@comment> > > > Troy > > > -----Original Message----- > From: Troy Sosamon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 10:32 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > I have done it using R:tango, IIS5 and W2k. R:tango is > Tango2000 and an > R:base database. > > I am not sure about how your DB handles the blobs, but to > load the files, I > upload the the file to a temp file on the server and then do > a directdbms > command to put the file into the database. > Pulling the pdf out if you write it to a temp file on the > server and link to > that file it is very easy. > It is a little trickier, but can be done where you pull the > file and send it > directly to the browser w/o needing to put it in a file on the server. > > Troy Sosamon > Denver, Co. > > > -----Original Message----- > From: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 10:08 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: PDF stored in db? > > > Tango2000, W2K server, IIS5, SQL2K > > I'm building an application to search and display lots of PDF > files. My > preference would be to store the files in the database, > rather than try > to organize and keep track of all the separate files. Does > anyone know > if this method will work with PDF files? If so, has anyone done a > similar app? I'm having problems getting the files loaded & > displayed - > I'm not sure if I'm doing it wrong, or if it's just not going to work. > > Thanks for any suggestions! > > jamileh > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
