yeah, just store the image names in the database, keeps it simple. also allows you to do things like cfdirectory on a folder full of images
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: <[EMAIL PROTECTED]> <doug@clevermonk cc: eys.co.uk> Subject: RE: [ cf-dev ] images into/from a db 09/18/02 04:10 PM Please respond to dev 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] -- ** 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]
