Hi all ! I have tried out this example from Troy and Scott but can't get it to work. It's probably some misunderstanding from me, but I try to get some help anyway. So I pull out my blob, a pdf file from the db (MSSQL) and use just a test taf to do this:
<@ASSIGN NAME="filedata" SCOPE="Local" VALUE="@@request$resultset[1,data]"> <@EXCLUDE> <@ASSIGN NAME=ENCODERESULTS VALUE=FALSE SCOPE=LOCAL> <@ASSIGN NAME=HttpHeader SCOPE=LOCAL VALUE="Content-type: application/pdf<@CRLF><@SETCOOKIES><@CRLF>"> </@EXCLUDE><@var request$filedata ENCODING=NONE> Now I would like Adobe reader to start inside my browser and show me the pdf, but instead I get: Client Error The response received from the application server is invalid. On some occasions it shows the pdf binary data instead. Hope for better knowledge after San Diego trip Cheers... Bengt Bredin, [EMAIL PROTECTED] Sweden 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
