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
-~----------~----~----~----~------~----~------~--~---
