I have a current assignment where will allow applicants to upload
resumes, and we want to upload the file **DIRECTLY** to an Oracle CLOB
field. I am presently trying working with Oracle 8i, but we will be
upgrading to Oracle 9i shortly.
Why do it this way?
1. My superiors want me to investigate doing it this way.
2. Oracle 9i apparently has some very powerful test searching
tools, which they may want to use.
I have never done this before, so I have been experimenting and trying
to learn. In all the research that I have done, the only way I've found
so far is, with ColdFusion, using the <CFFILE> tag to do either a READ
or READBINARY, put the result into a variable, and then insert the
variable contents into either a CLOB or BLOB field, respectively (I am
experimenting with both).
I then used the code in Listing 23.1, from the ADVANCED ColdfusionMX
book. In short, I'm selecting the LOB fields from the tables, creating a
Word document in a folder on the server, putting the LOB column contents
into the word document, and then creating a clickable link so you can
view it in MS Word.
Two problems:
1. First, since I am doing all this work to create the document
in a folder, this totally defeats the purpose of
putting it in the database, as opposed to just creating a file
on the server in the first place.
2. All the formatting tags (from a Word doc, let's say...) are
viewable when you view the document.
When you open the document, you see all the formatting tags,
basically rendering the document unreadable.
My question is this: Do you know of a way, USING COLDFUSION, to load the
file directly into the CLOB or BLOB field without doing all this File
processing, AND retaining all the file formatting.
Thanks
Frank Diana
Senior Programmer/Analyst
SUNY Administrative Systems
518.443.5036
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
