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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> >To: "toby z" <[EMAIL PROTECTED]>,"list mysql"
<[EMAIL PROTECTED]>
> >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 [EMAIL PROTECTED], wait an hour or so, and
> >you'll find a pdf version in your inbox.
> >(There's also a [EMAIL PROTECTED] 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:[EMAIL PROTECTED]]
> > > 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" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > 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" <[EMAIL PROTECTED]>
> > > > >To: toby gibbson <[EMAIL PROTECTED]>
> > > > >CC: [EMAIL PROTECTED]
> > > > >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
<[EMAIL PROTECTED]>
> > > > >>To unsubscribe, e-mail
> > > > >><[EMAIL PROTECTED]>
> > > > >>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
> > > > >[EMAIL PROTECTED]
> > > >
> > > >
> > > >
> > > >
> > > > _________________________________________________________________
> > > > 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 <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > > 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 <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > 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 <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
> _________________________________________________________________
> 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
