What about using cfqueryparam (I have not tested this though) <CFFILE ACTION="ReadBinary" FILE="full_path_name" VARIABLE="binObj">
INSERT INTO veryBigTable ( veryBigImageField ) VALUES ( <cfqueryparam cfsqltype="cf_sql_blob" value="#binObj#"> ) Joel -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Wednesday, 21 June 2006 11:50 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Saving Images into Database The database field type is image. Using MS SQL 2000 btw. >>> [EMAIL PROTECTED] 21/06/2006 11:37 am >>> You can use an ntext field and then use the toBase64() function to encode them, and the toBinary() function to decode them. This is coming from someone who has never used an image or binary field in a database before. <CFFILE ACTION="ReadBinary" FILE="full_path_name" VARIABLE="binObj"> INSERT INTO veryBigTable ( veryBigImageField ) VALUES ( '#toBase64(binObj)#' ) I agree though, save them to disk if security is not an issue Joel -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Mark Mandel Sent: Wednesday, 21 June 2006 11:28 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Saving Images into Database Save them to disk? Or does that sound too simple? :D Mark On 6/21/06, Scott Thornton <[EMAIL PROTECTED]> wrote: > > Hello, > > I use CFX_PUTIMAGE to save images into my database. > > I find it very slow. > > Is there any alternatives? -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---