Ben, sorry if I mislead you there. In our client/server software (VB) we update the table with a large pdf or zip file to a blob with text datatype. It's been done with oledb. My next mission will be to get it out with Witango and show it for the webusers. The point is that it works with MSSQL to put large files into a blob if the datatype is text. We did have problems with image datatype and therefore changed it.
All the best/ Bengt -----Ursprungligt meddelande----- Från: Ben Johansen [mailto:[EMAIL PROTECTED] Skickat: den 4 september 2003 17:40 Till: [EMAIL PROTECTED] Ämne: 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
