I realized I didn't explicitly answer your question:
I can upload any file type into the db, and download it to a client. The
only restriction is that the file extension be in the mime type table, a
portion of which is below:
id type extension
38 video/quicktime .mov
37 video/mpeg .mpg
36 text/xml .xml
35 text/tab-separated-values .tsv
34 text/sgml .sgm
33 text/rtf .rtf
32 text/richtext .rtx
>Have you done this with __PDF__ files stored in __MSSQL__? If so, how
>are you loading the files into the db?
>
>There is more to this issue than just how to set the HTTP header for
>display of pdf files. I can read the file contents and display as a
>pdf; it's the database piece that causes a problem. I suspect Bengt is
>running into the same issues.
>
>Thanks. j
>
>
>> -----Original Message-----
>> From: Bill Conlon [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, September 17, 2003 2:41 PM
>> To: [EMAIL PROTECTED]
>> Subject: RE: Witango-Talk: PDF stored in db?
>>
>>
>> Here's what works for me:
>>
>> 1. Query my db (three tables for mime type, media meta data, and the
>> media data itself -- but you could put this into one table)
>>
>> 2. Set up the request scope variables
>> <@ROWS>
>> <@ASSIGN NAME="type" SCOPE="request" VALUE=<@COLUMN
>> "mime.type">> <@ASSIGN NAME="date" SCOPE="request" VALUE=<@COLUMN
>> "media_description.date_modified">>
>> <@ASSIGN NAME="size" SCOPE="request" VALUE=<@COLUMN
>> "media.size">> <@ASSIGN NAME="filename" SCOPE="request"
>> VALUE=<@COLUMN "media.filename">> <@ASSIGN NAME="file"
>> SCOPE="request" VALUE=<@COLUMN "media.data">> </@ROWS>
>>
>> 3. Set up the HTTP header
>> <@PURGERESULTS><@assign name="encodeResults" scope="request"
>> value="false"><@ASSIGN NAME="httpHeader" SCOPE="request"
>> encoding="none"
>> VALUE="HTTP/1.1 200 OK<@CRLF>Server: Apache
>> 2.0.046<@CRLF>Accept-Ranges:
>> bytes<@CRLF>Content-Type: @@request$type<@CRLF>Content-Disposition:
>> inline; filename=@@request$filename<@CRLF>Last-Modified: <@VAR
>> NAME="date" scope="request" format="datetime"><@CRLF>Content-Length:
>> @@request$size<@CRLF><@CRLF>"><@VAR NAME="file" SCOPE="request"
>> ENCODING="none">
>>
>> >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
>> >
>>
>>
>> Bill Conlon
>>
>> To the Point
>> 345 California Avenue Suite 2
>> Palo Alto, CA 94306
>>
>> office: 650.327.2175
>> fax: 650.329.8335
>> mobile: 650.906.9929
>> e-mail: mailto:[EMAIL PROTECTED]
>> web: http://www.tothept.com
>>
>>
>> ______________________________________________________________
>> __________
>> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>>
>________________________________________________________________________
>TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
>
Bill Conlon
To the Point
345 California Avenue Suite 2
Palo Alto, CA 94306
office: 650.327.2175
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
