Hiya Bengt! 1. Check the binary data in your blob against your original file. How are you putting the PDF in?
2. Check the pdf binary data that is displayed against the binary data in the original. I've still not gotten this to work properly, due to a null character used in the PDF format. That characters always truncated the data either at upload or at read; I haven't found a workaround yet. Other folks said they had gotten it working, but they were either doing image files rather than PDF, or were not on MSSQL. (I had to drop the issue when I hadn't managed to resolve it after several days.) If you can give me more info about how your process works, I'll pull the pertinent info I've collected and forward it. Good luck! jamileh > -----Original Message----- > From: Bengt Bredin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 9:28 AM > To: [EMAIL PROTECTED] > Subject: SV: Witango-Talk: PDF stored in db? > > > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
