This will store the file as a base64 representation of the file. <cffile action="READBINARY" file="yourfile" variable="blobData"> <cfset blobBase64 = toBase64(blobData)>
Then just insert blobBase64 to an nText field in your db. To get the file out... <cfset blobBinary = toBinary(queryname.blobBase64)> <cffile action="WRITE" file="yourfile" output="#blobBinary#" addnewline="No" nameconflict="OVERWRITE"> Works for me. -----Original Message----- From: Discover Antartica [mailto:[EMAIL PROTECTED] Sent: 19 January 2005 16:55 To: CF-Talk Subject: Can we use CFFILE for this? Does anyone know how to upload a file into a column in a database table using Coldfusion? Can we use <CFFILE>? --------------------------------- Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54