Yeah, thats how I've always done it before and is probably how I'll do it now as well. I was just curious as to how it might be done with CF as it seems quite easy with php.
-----Original Message----- From: Stephen Fernandez [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 16:35 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] images into/from a db this topic comes up quite often, i think the general consensus seems to be that its a lot easier to save the image in a directory and just save the location of the image file in the datbase. -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:11 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] images into/from a db true. missed that. Im still not convinced that CF can input and extract images from a db easily. it doesnt seem to deal with binary data like that from what I've been trying and researching. Im only doing it to test out a method of accomplishing a task so might end up using a different method. Was just wondering if anyone had any thoughts? Will let you know what I find anyhows :) D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 September 2002 14:57 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] images into/from a db image.cfm <img src="yourFilePath/#image#"> All that File.ServerFile gives you is the name of the uploaded file, not the binary content of that file. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Douglas McKenzie" To: "CF-Dev" <[EMAIL PROTECTED]> <doug@clevermonk cc: eys.co.uk> Subject: [ cf-dev ] images into/from a db 09/18/02 02:16 PM Please respond to dev Hi, Im testing out a system which might add images into a MySql database. Currently I've got the images going into it (I think) using: <cffile action=upload> <cfset newfile="cffile.serverfile"> <cfquery.....> insert into table (image) Values (#newfile#) </cfquery> Looking at the db, the image seems to be in there. Now to view it, Im trying this: <img src="image.cfm?id=1"> where image.cfm contains: <cfcontent type="image/gif"> <cfoutput>#image#</cfoutput> AND ALSO: <cfcontent type="image/gif" file="#image#"> to no avail. any pointers on how to read the image out of the db? Cheers, Douglas McKenzie ---------------------------------------- Internet Developer / Designer [EMAIL PROTECTED] 07984 462 516 ---------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
