Yeah, that's right, that is what I was running into. I am wondering if it will take "Quoted-Printable" or "Base-64" encoding?
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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: PDF stored in db? It seems to be some sort of strange character that's causing the problem. One file uploads as 40 characters, the other as 1085. My text editor shows hexcode 00 at those locations. I'm inserting as text, with quotes around the data; dropping the quotes causes various errors. > -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 11:11 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > That is the problem I had and it was weird, it would stop > when it reached the first space in, huh! I said this is text. > I think I even tried wrapping it in quotes. > > 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: Wilcox, Jamileh (HSC) [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 9:06 AM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > 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 > > ______________________________________________________________ > __________ > 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
