To be continued...what that mean?
Can some one help on second part of this?
The "UploadFile.cmf", I did try to upload the file and save in oracle database but fail, I am having hard time on this issue, can not find any where explanning on this matter.
Here is the code, please help, very appreciated.
- <HTML>
-
<HEAD>
-
<TITLE>Load File</TITLE>
-
</HEAD>
-
<BODY>
-
-
<cfif isdefined("Form.Submit")
-
and trim(form.FileName) neq "">
-
<cftry>
-
<cffile action="upload"
-
filefield="form.FileName"
-
destination="C:\Upload\"
-
nameconflict="makeunique"
-
accept="application/octet-stream, application/vnd.ms-excel, image/*">
-
<cffile
-
action = "readbinary"
-
file = "C:\temp\#cffile.serverFile#"
-
variable = "blob">
-
-
<!--cfquery name="testing" datasource="TEST">
-
insert into ADD (load_file)
-
values (
-
<cfqueryparam
-
value="#blob#"
-
cfsqltype="cf_sql_blob">
-
)
-
</cfquery-->
-
-
</cftry>
-
</cfif>
-
-
</BODY>
-
</HTML>
-
The problem is when I upload the file, it doesn't do any thing, and I also using SQL Plus to check and see any file insert, but nothing.
Thanks in advance,