Alexander, I was wondering if you could post the code that also does the image upload to SQL. I have tried but I still cannot get it work correctly. Also could the same upload be used for other types - such as word or excel documents? I would like to be able to store these documents in a database also. I would be using 4.5 currently but will be using 6.0 real soon - also SQL 7.0 but going to 2000.
Thanks in advance. Mario -----Original Message----- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:03 PM To: CF-Talk Subject: RE: Saving an "Image" Datatype in CF5 Some of my code... <cfset path = "d:\temp\"> <cfset thisfilename = path & "id_" & getBinaryData.objectID & "-" & getBinaryData.uuid & "." & getBinaryData.dataExtension > <cfset tobin = tobinary(getBinaryData.base64String)> <cfif fileexists(thisfilename)> <cffile action="DELETE" file="#thisfilename#"> </cfif> <cffile action="WRITE" file="#thisfilename#" output="#tobin#" addnewline="No"> <cfset contenttype = "image/" & getBinaryData.dataExtension > <cfcontent file="#thisfilename#" type="#contenttype#"> I also do the upload of theimage to sql via cf... However I store the data in base64 (string) in an text field. That is why I do the tobinary() function on the way out. I am still waiting for raw data streaming like php in cf. in php you can do this without writing a temp file. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-----Original Message----- |From: Ben Koshy [mailto:[EMAIL PROTECTED]] |Sent: Monday, October 07, 2002 2:24 PM |To: CF-Talk |Subject: Saving an "Image" Datatype in CF5 | | |I've got JPEG images being saved right in the SQL 2000 |Database as an "Image" Datatype... and I'm wondering how I get |Cold Fusion to read this data and save it to a file? I tried |a simple CFFILE action="write" to write out that field but |that didn't seem to work. I'm using CF5 btw. | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
