Thanks I was looking for a opinion on this. I have heard of it being done
but was not sure of any benefits in storing binary files to the database.
  -----Original Message-----
  From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
  Sent: Thursday, February 26, 2004 11:02 AM
  To: CF-Talk
  Subject: Re: How do you store a image

  Well, you really shouldnt. You'll end up weighing down your database for
some minor benefits. But if you must.

  use the 'readbinary' action for cfile to pull it into CF.

  then pass that data to mySQL. Make sure the column you are going to store
the image is of type LONGBLOB.

  But yeah, I recommend you just store a reference to the image in teh
database, rather than the image itself. Database are designed to serve up
data, not files.

  -Adam

  > -----Original Message-----
  > From: JT [mailto:[EMAIL PROTECTED]
  > Sent: Thursday, February 26, 2004 05:50 PM
  > To: 'CF-Talk'
  > Subject: How do you store a image
  >
  > How can I store a image binary file in a database.
  >
  > I want to upload a image and place the actual jog in a MySQL database.
Can
  > this be done? if so what steps would I take.
  >
  > thanks for any Help
  > JT
  >
  >
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to