I searched all over the archives and could not find an answer to this
question.
First of all, for all those who are going to reply and tell me that
its better to just store them on disk and store the path in the database,
I've already been through that. This application will 'publish' sites
from a database to disk, so when the outside world views the sites
the images will be read from disk. The images are just easier to manage
if they are stored in the database alongside their respective data.
Also if I stored the images on disk I would have to come up with a scheme
to copy the image files across all the servers in the cluster. (And I
would have lots of directories to manage, because it would be bad to
store 25000 images in one directory, etc, etc etc.)
So has anybody been able to stick uploaded images in a database? I was
hoping it would be as easy as <INPUT TYPE=FILE NAME="incoming"> and then
INSERT INTO TABLE VALUES("#incoming"). I havn't got that far yet, I was
just trying to display #incoming# directly and verify that it does have
the binary contents of the uploaded file. This works fine when I upload
text files, #incoming# displays the contents of the text file right in
my web page. But when I try it with an image, #incoming# contains
"/tmp/ACK35hFjj", and the part after /tmp/ changes randomly. What the
heck is this? I tried doing a CFFILE ACTION="READ" on the #incoming#
value, thinking it was a path to the binary data or something, but
CFFILE says that file does not exist.
Any ideas?
Thank you much.
Ryan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
