Hi Will, 

the readbinary and writebinary actions for <cffile> were designed for this sort of 
thing... 

<cffile action="upload"... > 
<cffile action="readbinary" file="..." variable="mybinarydata">
<cfquery name="myupdate" datasource="...">
        UPDATE mytable SET 
        filebinarydata = '#mybinarydata#' 
        WHERE mytableid = #mytableid#
</cfquery>

I'm not absolutely certain about the syntax, but something like that ought to work -- 
I believe the quotes are correct, but I haven't done this recently. 

Hope this helps, 

Isaac
www.turnkey.to
954-776-0046

______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to