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
FileUploadToDb.taf
Description: FileUploadToDb.taf