yep, replying to self has to be as bad as talking to self .. cracking up ...
got this far .. seems like the data has to go into an ntext type .. binary said truncated, and varbinary said wrong data type .. so as it's a string ... ? At the end is my feeble attempt to get the data out again ... arrrrrgggghhhhhh <cffile action = "readBinary" file = "\apache\apache2\dating\profiles\photos\thumbs\#thumbname#" variable = "thumb1"> <cffile action = "readBinary" file = "\apache\apache2\dating\profiles\photos\thumbs\small\#thumbname#" variable = "thumb2"> <!-- convert to base 64 --> <cfoutput> <cfset thumb1_64=tobase64(thumb1)> <cfset thumb2_64=tobase64(thumb2)> </cfoutput> <cfoutput> <cfquery datasource="dating"> UPDATE Registered SET PhotoThumbB = '#thumb1_64#', PhotoThumbSmallB = '#thumb2_64#' WHERE Registered.RegisterID = #session.registerID# </cfquery> </cfoutput> <cfquery name="Register2" datasource="dating"> SELECT * FROM dbo.Registered WHERE dbo.Registered.RegisterID = #session.registerID# </cfquery> <cfoutput> <cfset binaryData = toBinary(#register2.photothumbsmallB#)> <img src="#binarydata#"> </cfoutput> ----- Original Message ----- From: "Jenny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 21, 2004 9:45 PM 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] > > --- 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]
