How would you do that uploading files? I've only seen it in email.
> -----Original Message----- > From: Ben Johansen [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 1:13 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: PDF stored in db? > > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
