> I am sure that this is a newbie question, but how do I allow
> someone to insert a file into my Oracle database? I have set
> up a file insert form element, but from there I am lost. The
> database is set up to accept a file in the table I have created,
> but I don't know how to get the file there.
>
> The <CFFORM> Tag looks like it only stores a file in a specified
> folder on the web server. What I want to do is store that file
> in an Oracle 8i database. Can anyone give me an idea on what I
> need to do?
Unfortunately, this isn't easy with CF. CF can't do much with binary data,
so you'll have to use CFFILE to store the uploaded binary file on the
filesystem, then use something outside CF to update the record with the
binary file data. I believe there are CFX tags to do this on the Developers'
Exchange. CF 4.5.x does allow you to do some simple things with binary data,
but I've been unsuccessful in using it to put binary data into a database
field. You could, alternatively, convert the binary data to base64 and
insert that instead; you could do that from within CF, but you'd still have
to use CFFILE to store the file on the filesystem, and then read it in,
convert it to base64, then use that string.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
