Erm..too many names to store in a DB...? If you store them in the DB be prepared for your DB to start growing into a behemoth of a database in no time.
-----Original Message----- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 21:46 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE .... 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] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- 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]
