Yup, text and image columns can hold huge amounts of data...but you have to put it in 8KB at a time. Is that a great system, or what?
*g* > -----Original Message----- > From: Bill Conlon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 17, 2003 3:51 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > As Seargeant Schultz said" "I know nothing" about MSSQL. I have had > issues with uploading blobs greater than 1MB into mysql (this > requires > the variable max_allowed_packet be set), and I presume there is a > parameter in MSSQL. > > But ... my copy of Microsoft SQL Server Administrator Guide > says binary > columns are limited to 8000 bytes, though text and image > columns can be > 2^31. > > >Bill this is great, but are you working with MS SQL Server? > > > >The issue here is mainly inserting blobs over 8k not just > into any DB > >but MSSQL > > > > > >Ben Johansen - http://www.pcforge.com > >Authorized Witango & MDaemon Reseller > >Available for Witango Developement > > > > > >-----Original Message----- > >From: Bill Conlon [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, September 17, 2003 1:27 PM > >To: [EMAIL PROTECTED] > >Subject: RE: Witango-Talk: PDF stored in db? > > > >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 > > > >_____________________________________________________________ > __________ > >_ > >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