With CFCONTENT you can set to to delete the file from disk after it is served.
> How do you clean up the images, this is a concern as the web space is > limited. And uuid files would mean more disk space. So there must be a > way to do this with out saving as a temp file first! > > Can anyone explain to me why this doesn't work, so that I can find a > solution to this? > > > -----Original Message----- > From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] > Sent: Friday, 15 March 2002 12:22 AM > To: CF-Talk > Subject: RE: Image and DB Solution needed > > How are you storing the image in the db? As binary or string? Either way > cfcontent needs a file, so take query.test, write to file and then read > the > file back as action=readbinary then use that var in the cfoutput. > > Some code I use > > <cfquery name="getBinaryData" datasource="#dsn#"> > SELECT binaryString, dataExtension > FROM binaryData > WHERE objectID = #url.objectID# > AND uuid = '#url.uuid#' > </cfquery> > > <cfset path = "d:\temp\"> > > <cfset thisfilename = path & "id_" & url.objectID & "-" & url.uuid & "." > & > getBinaryData.dataExtension > > > <cfset tobin = tobinary(getBinaryData.binaryString)> > > <cfif fileexists(thisfilename)> > <cffile action="DELETE" file="#thisfilename#"> > </cfif> > <cffile action="WRITE" file="#thisfilename#" output="#tobin#" > addnewline="No"> > > <cfset contenttype = "image/" & getBinaryData.dataExtension > > > <cfcontent file="#thisfilename#" type="#contenttype#"> > > > I store the image as base64 encoded text in a text column in the db. On > the > way out I transfer it back to binary. I really would like cf to let me > do > this without writing a file to disc, but alas... No dice. Maybe in neo. > > Good luck, > > Alexander Sicular > Chief Technology Architect > Neurological Institute of New York > Columbia University > as867 [at] columbia {dot} edu > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
