We have a telemedicine system that uses SQL 2000 Server and CF 5 - The medical images are drawn from SQL into the .cfm page
Lisa Cruz Teledermatology Program Manager Office of the Assistant Chief of Staff for Information Management Great Plains Regional Medical Command 2410 Stanley Rd., Ste. B16 Ft Sam Houston, TX 78234-6230 Telephone: 210-295-2705 DSN 421.2705 Facsimile: 210.295.2345 DSN 421.2345 -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:11 AM 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]
