List:General Discussion« Previous MessageNext Message »
From:kayamboo Date:October 10 2002 12:21am
Subject:Re: storing PDF files in mysql ?????
View as plain text  
Hi toby

   Just replace the .gif with your .pdf. I hope this will work for you.
INSERT INTO photo(name , pic, picname) values( 'raman',
load_file('e:/mysql/images/Click.gif'),'Click.gif') ;

SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ;

UPDATE photo SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name =
'velan' ;

SELECT pic FROM photo WHERE name = 'velan' INTO DUMPFILE 'C:/TEMP/pic2.gif'



Good Luck


----- Original Message -----
From: "toby z" <smokeywater@stripped>
To: <coders@stripped>; <mysql@stripped>;
<kayamboosuresh@stripped>
Sent: Wednesday, October 09, 2002 9:45 PM
Subject: RE: storing PDF files in mysql ?????


> thnx guyz
>
> 1) i m tryin to put the pdf file into a blob field but i cant insert it
like
> normal text how shall i go about inserting it ????
>
>
>
> 2) i m in the process of converting the word doccuments to pdf got this
> acrobat disteller n m havin a million probz with that alone like the
> security issue
>
> I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with
> this thing n wouldnt mind me mailin him/her plz do lemme no
>
>
> guyz plz hlp .....
>
> thnx a billion
>
> toby
>
>
> >From: "Sqlcoders.com Programming Dept" <coders@stripped>
> >To: "toby z" <smokeywater@stripped>,"list mysql"
<mysql@stripped>
> >Subject: RE: storing PDF files in mysql ?????
> >Date: Tue, 8 Oct 2002 21:47:23 -0600
> >
> >Toby,
> >If I understand correctly you want to perform two distinct actions:
> >1. Convert Microsoft Office Word .doc files into .pdf
> >2. Store those pdf's in MySQL.
> >
> >You should look into (via google.com) some doc to pdf converters. An
> >example
> >is this com object:
> >http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy,
> >it costs $219 and converts .doc to .pdf.
> >
> >If you can convert the .doc's into .html files, you might be able to get
> >away with using Adobe's free email converter service.
> >Email the HTML document to html2pdf@stripped, wait an hour or so, and
> >you'll find a pdf version in your inbox.
> >(There's also a txt2pdf@stripped address if you dont want to use html,
but
> >I think you wanted to keep formatting).
> >
> >Once you have the document in PDF, it's a relatively trivial action to
> >store
> >the documents in your MySQL database.
> >
> >HTH,
> >William.
> >
> > > -----Original Message-----
> > > From: kayamboo [mailto:kayamboosuresh@stripped]
> > > Sent: 08 October 2002 18:20
> > > To: toby z
> > > Cc: list mysql
> > > Subject: Re: storing PDF files in mysql ?????
> > >
> > >
> > > I think if you decide to store in the blob,
> > > whatever it is, a pdf or jpeg or bmp, it is going to be in binary
> >format.
> > > While you need to display it back, just convert them back to
> > > whatever format
> > > you like.
> > >
> > > Else there is always the choice of just storing the path in your
> >database.
> > >
> > > By the way, which language you are using to write your applications.
> > > If it is delphi, I can send you some sample code
> > >
> > >
> > > regards
> > >
> > > ----- Original Message -----
> > > From: "toby z" <smokeywater@stripped>
> > > To: <r.j.dobson@stripped>
> > > Cc: <mysql@stripped>
> > > Sent: Wednesday, October 09, 2002 1:14 AM
> > > Subject: Re: storing PDF files in mysql ?????
> > >
> > >
> > > > thnx rich
> > > >
> > > > but u see the problem iz my clients want their text IN pdf format to
> >be
> > > >
> > > > displayed with all these colors on the page in other  words they
want
> > > >
> > > > their sites layout to be maintained on the pages showing this pdf
text
> > > >
> > > > as they are pretty concerned bout security
> > > >
> > > >
> > > > so what do i do now ????
> > > >
> > > >
> > > > thnx a mill
> > > >
> > > > toby
> > > >
> > > >
> > > >
> > > > >From: "R.Dobson" <r.j.dobson@stripped>
> > > > >To: toby gibbson <smokeywater@stripped>
> > > > >CC: mysql@stripped
> > > > >Subject: Re: storing PDF files in mysql ?????
> > > > >Date: Tue, 08 Oct 2002 16:35:56 +0100
> > > > >
> > > > >
> > > > >hi,
> > > > >2 ways to do this:
> > > > >
> > > > >a) don't store the file actually in the db but store the path to
it.
> > > > >
> > > > >b)use the function LOAD_FILE(filename) to get the contents of
> > > a file as a
> > > > >string value and store as a blob.
> > > > >
> > > > >decide which to use depending on how many pics you have
> > > > >
> > > > >cheers
> > > > >Rich
> > > > >
> > > > >toby gibbson wrote:
> > > > >
> > > > >>ok guyz more trouble
> > > > >>
> > > > >>now im supposed to convert all the text (from ms word) to PDF
> and
> >put
> > > the
> > > > >>pdf files in mysql db
> > > > >>
> > > > >>now i ve really got myslf stuck havent i
> > > > >>
> > > > >>can anyone plz hlp ????
> > > > >>
> > > > >>thnx a million
> > > > >>
> > > > >>stuck az usual
> > > > >>
> > > > >>toby .....
> > > > >>
> > > > >>
> > > > >>
> > > >
> >>_________________________________________________________________
> > > > >>Chat with friends online, try MSN Messenger:
> >http://messenger.msn.com
> > > > >>
> > > > >>
> > > >
> > >>---------------------------------------------------------------------
> > > > >>Before posting, please check:
> > > > >>   http://www.mysql.com/manual.php   (the manual)
> > > > >>   http://lists.mysql.com/           (the list archive)
> > > > >>
> > > > >>To request this thread, e-mail
<mysql-thread121613@stripped>
> > > > >>To unsubscribe, e-mail
> > > >
> >><mysql-unsubscribe-r.j.dobson=qmul.ac.uk@stripped>
> > > > >>Trouble unsubscribing? Try:
> >http://lists.mysql.com/php/unsubscribe.php
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > > >--
> > > > >
> > > > >Richard Dobson
> > > > >Database Administrator
> > > > >MRC Bright Study
> > > > >Clinical Pharmacolgy
> > > > >St Bartholomew's and the Royal London
> > > > >School of Medicine and Dentistry
> > > > >Charterhouse Square
> > > > >London EC1M 6BQ
> > > > >Tel: 020-7882-5670
> > > > >Mob: 07711-522926
> > > > >Fax: 020-7882-5672
> > > > >r.j.dobson@stripped
> > > >
> > > >
> > > >
> > > >
> > > > _________________________________________________________________
> > > > Send and receive Hotmail on your mobile device:
http://mobile.msn.com
> > > >
> > > >
> > >
> ---------------------------------------------------------------------
> > > > Before posting, please check:
> > > >    http://www.mysql.com/manual.php   (the manual)
> > > >    http://lists.mysql.com/           (the list archive)
> > > >
> > > > To request this thread, e-mail
> <mysql-thread121643@stripped>
> > > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-kayamboosuresh=softhome.net@stripped>
> > > > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> > > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread121695@stripped>
> > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-coders=sqlcoders.com@stripped>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> >
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> >To request this thread, e-mail <mysql-thread121710@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-smokeywater=hotmail.com@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>

Thread
storing PDF files in mysql ?????toby gibbson8 Oct
  • Re: storing PDF files in mysql ?????R.Dobson8 Oct
Re: storing PDF files in mysql ?????toby z8 Oct
  • Re: storing PDF files in mysql ?????kayamboo9 Oct
    • RE: storing PDF files in mysql ?????Sqlcoders.com Programming Dept9 Oct
    • RE: storing PDF files in mysql ?????Alexis Antonakis9 Oct
      • Re: storing PDF files in mysql ?????Michael T. Babcock9 Oct
      • AW: storing PDF files in mysql ?????Kai Zaunick9 Oct
      • Re: storing PDF files in mysql ?????kayamboo10 Oct
RE: storing PDF files in mysql ?????toby z9 Oct
  • Re: storing PDF files in mysql ?????kayamboo10 Oct
RE: storing PDF files in mysql ?????Jan Steinman9 Oct
RE: storing PDF files in mysql ?????toby z10 Oct