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 -------------------------------------------------------------