I take it back. The reason I'm having problems with the display is that it's not inserting the full file, only about 40 chars worth.
I'm reworking it now, so any hints from Bengt would be most timely. :) j > -----Original Message----- > From: Wilcox, Jamileh (HSC) > Sent: Thursday, September 04, 2003 10:46 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > Actually, I've gotten the data to insert into a Text field. > At the moment, I'm trying to get it back out again. :) > > P.S. Access might work, on very small files. Max looks to > be ~65K. Since my two sample files are approaching that, I > don't think it's workable for me. > > Here's the taf I used. > > > > > -----Original Message----- > > From: Ben Johansen [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 04, 2003 10:40 AM > > To: [EMAIL PROTECTED] > > Subject: RE: Witango-Talk: PDF stored in db? > > > > > > Wow, I tried Text and it wouldn't take the data, Jamileh and > > the rest of the list and I would be interested in a snippet > > of that insert technique. > > > > Ben Johansen - http://www.pcforge.com > > Authorized Witango Reseller > http://www.pcforge.com/WitangoGoodies.htm > > Authorized MDaemon Mail Server Reseller > > http://www.pcforge.com/AltN.htm > > > > > > -----Original Message----- > > From: Bengt Bredin [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 04, 2003 5:07 AM > > To: [EMAIL PROTECTED] > > Subject: SV: Witango-Talk: PDF stored in db? > > > > Ben ! > > > > For you info: > > We also had problems with IMAGE datatype for the blob. But we > > changed it to text and it works. We can insert big files (7M) > > of pdf or zip files into MSSQL. > > > > Bengt Bredin > > [EMAIL PROTECTED] > > > > > > -----Ursprungligt meddelande----- > > Fr�n: Ben Johansen [mailto:[EMAIL PROTECTED] > > Skickat: den 3 september 2003 19:27 > > Till: [EMAIL PROTECTED] > > �mne: RE: Witango-Talk: PDF stored in db? > > > > Ok, this is great work, if they were using a user friendly > > database, something other than M$SQL. > > > > Yes M$SQL says you can set up an IMAGE datatype of up to > > 2Gig. But this is just for spec. try inserting. The max MSSQL > > can take is 8k blocks and so your nice IMAGE or PDF will need > > to be broken into 8k blocks and stored in M$SQLs special > > format with a reference pointer to all the little 8k blocks > > So forget doing a simple Insert into dba.ImageTable > > (ImageData) values (@@local$LoadedImageData) > > > > M$SQL is playing the TPC.org game of Transactions per second > > to say they have the fastest. Of course you can be faster if > > you drop functionality. > > > > Sorry venting here. This is why I use database based on > > functionality like R:Base or Sybase SQL Anywhere. > > > > There might be a COM object that you could use out there, > > haven't looked. > > > > Heck, you could probably setup a second database in Access to > > store the PDFs/Images > > > > > > Ben Johansen - http://www.pcforge.com > > Authorized Witango Reseller > http://www.pcforge.com/WitangoGoodies.htm > > Authorized MDaemon Mail Server Reseller > > http://www.pcforge.com/AltN.htm > > > > > > -----Original Message----- > > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 03, 2003 10:13 AM > > To: [EMAIL PROTECTED] > > Subject: RE: Witango-Talk: PDF stored in db? > > > > 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 > > > > ______________________________________________________________ > > __________ > > 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
