Mike,
Have you looked into using cfimage tag to reference, render, or manipulate BLOB
data? If I recall, you can directly feed a database call into a cfimge tag.
Cheers,
Teddy
Sent from my iPad
On Apr 1, 2013, at 4:12 PM, Mike Staver sta...@fimble.com wrote:
I've been thinking about keeping all user-uploaded images in the DB for one
of my projects. I know how I will work the process to get them into the DB
and keep them off the hard drive. It would go something like:
1) Image uploaded to temp file system location from form post.
2) Image inserted into DB as blob.
3) Temp image removed from file system.
Displaying the images is a bit more work I think. I assume I'd have to follow
a similar process in reverse:
1) Extract image from DB to temp file system location.
2) Display it in HTML via web server as img tag.
3) Remove image after a certain period of time...
Step 3 has me wondering: How long should I wait before removing the image
from the file system? Meaning - in theory, I could remove the image before it
would even have a chance to display via the web server, and I don't want
that. Anybody have a good process to do this already? I'd love if there was a
way to display an image directly from the DB, but I'm not aware of such a
method. I'll probably just fall back on leaving those images on the file
system as part of the display, and have my code check for their existence
before retrieving them again. I didn't want to have to worry about the disk
space, but I can't think of another way.
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-
-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-