Hi Adrian, Thanks, but just too many files to manage in this way.
I've been playing around with base 64 and am struggling. I get a photo uploaed, create thumbs, then need to store the thumbs. Hope the below makes some sense and someone can tell me what silly thing I am doing. <cfoutput> <cfexecute name = "c:\Program Files\ImageMagick-6.0.1-Q16\convert.exe" arguments = "-sample 200x200 c:\apache\apache2\dating\profiles\photos\#search_word[1]# c:\apache\apache2\dating\profiles\photos\thumbs\#thumbname#"></cfexecute> <cfexecute name = "c:\Program Files\ImageMagick-6.0.1-Q16\convert.exe" arguments = "-sample 125x125 c:\apache\apache2\dating\profiles\photos\#search_word[1]# c:\apache\apache2\dating\profiles\photos\thumbs\small\#thumbname#"></cfexecu te> </cfoutput> <cffile action = "readBinary" file = "c:\apache\apache2\dating\profiles\photos\thumbs\#thumbname#" variable = "thumb1"> <cffile action = "readBinary" file = "c:\apache\apache2\dating\profiles\photos\thumbs\small\#thumbname#" variable = "thumb2"><cfabort> <!-- convert to base 64 --> <cfoutput> <cfset thumb1_64=tobase64(thumb1)> <cfset thumb2_64=tobase64(thumb2)> </cfoutput> <cfoutput> <cfquery datasource="dating"> UPDATE Registered SET PhotoThumb = '#thumb1#', PhotoThumbSmall = '#thumb2#' WHERE Registered.RegisterID = #session.registerID# </cfquery> </cfoutput> ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 21, 2004 6:28 PM Subject: RE: [ cf-dev ] CFFILE .... > Don't store them directly in the DB, instead use cfdirectory to get them all > and put their names in a table. > > <cfdirectory action="list" directory="#pathToImages#" name="qDir"> > > <cfloop query="qDir"> > > <cfquery> > INSERT INTO ..... > </cfquery> > > </loop> > > About as quick and easy as it gets I think... > > Ade > > -----Original Message----- > From: Jenny [mailto:[EMAIL PROTECTED] > Sent: 21 August 2004 16:57 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] CFFILE .... > > > Ok, this is getting messy storing pics as files .. is there an easy way to > store them in an ms sql 7 database please? > > Thanks, Jenny > > ----- Original Message ----- > From: "Jenny" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, August 21, 2004 4:33 PM > Subject: Re: [ cf-dev ] CFFILE .... > > > > Thanks Terry, I'd missed the fileexists function. > > > > Jenny > > > > ----- Original Message ----- > > From: "Terry Riley" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Saturday, August 21, 2004 12:24 PM > > Subject: Re: [ cf-dev ] CFFILE .... > > > > > > > Sure. > > > > > > Something like this: > > > > > > <cfif FileExists(#variables.x_file_name#)> > > > <cffile action="DELETE" file="#variables.x_file_name#"> > > > </cfif> > > > > > > Of course, you'll have to substitute your own file name for the > variable. > > > > > > Cheers > > > Terry > > > > > > ----- Original Message ----- > > > > > > > Hi all, > > > > > > > > Is there a way to check for the existence of a file before doing a > > > > cffile > > > > delete, please? > > > > > > > > Thanks, Jen > > > > > > > > > > > > (have to get in plug for new web site .. > http://www.chicksNchaps.co.uk) > > > > > > > > > > > > > > > > > > > > -- > > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > CFDeveloper Sponsors and contributors:- > > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided > > by activepdf.com* > > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > > proworkflow.com* > > > *Tutorials provided by helmguru.com* :: *Lists hosted by > > gradwell.com* > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 > > > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- > > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided > by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
