I started a thread with the same question a few weeks back. You can
do it, but others convinced me that there is little to be gained and
a lot of overhead in the db.
The net... you are better off storing the files in the file system
(that's what the db does anyway, only less efficiently).
HTH
Dick
At 4:18 PM -0600 12/29/00, Rick Lamb wrote:
>This is also how I've always done it. But I'm curious if there is a way to
>store the actual image in the database. I was thinking maybe I could use one
>of CF's binary functions to convert it to binary, then to wddx or store it
>directly in the database as binary. If it wasn't much of a performance hit,
>and is possible, seems to be a much cleaner solution.
>
>Rick
>
>-----Original Message-----
>From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
>Sent: Friday, December 29, 2000 5:07 PM
>To: CF-Talk
>Subject: Re: storing images in SQL database
>
>
>Quoting Rick Lamb <[EMAIL PROTECTED]>:
>
>> Could you guys give me suggestions for the best way to store images in
>> a
>> database.
>
>I usually just store the image name in the database. If necessary you could
>also
>store the path to the image in the database. Other than that I don't know
>what
>you need to know.
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
