You can easily write a temp file clean up script to check file datetimes and
delete all those that are say 1 day old... Whatever. Uuid is just being used
as a name, not additional file space. However storing the image as base64 in
the db does add about 33% to the size of the file.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-----Original Message-----
|From: Andrew Scott [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, March 14, 2002 9:18 AM
|To: CF-Talk
|Subject: RE: Image and DB Solution needed
|
|
|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
|
|
|
______________________________________________________________________
Get Your Own Dedicated Windows 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=coldfusionb
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
