But how would you use it in an HTML page? -----Original Message----- From: Christopher Dawes [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE ....
You don't have to write it to file first. Use toBase64 and toBinary to get it in and out for display. -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sunday, 22 August 2004 8:30 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE .... I think you may have to write the image to disk before displaying it if you store it in the DB. Go on, store it in the file system, you know you want to! :OD Seriously though, it'll make life easier. Why do you think storing in the DB will be better? Ade -----Original Message----- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 06:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE .... hi Ade, Yes, that's the bit I'm stuck on. How to display the image now I've stored it as text. And yep, it's a dating site. Shameless plug: http://www.chicksNchaps.co.uk Thanks for your help, Jenny ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 21, 2004 11:08 PM Subject: RE: [ cf-dev ] CFFILE .... > I think you might be making problems for yourself further down the line. But > first thing I noticed is you have... > > <img src="#binarydata#"> > > ... if src isn't a path to a file it won't work. cfcontent might be what you > want but I'd still suggest storing them in the file system and store data > about the images in the DB. I'm sure that's the general consensus on the > list too. > > BTW, is this a dating site you're doing, dating\profiles\photos, just call > me Miss Marple :OD > > Ade > > -----Original Message----- > From: Jenny [mailto:[EMAIL PROTECTED] > Sent: 21 August 2004 22:44 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] CFFILE .... > > > 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> -- 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] -- 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]
