To be continued...wha t 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,
4 3950
Addition for that question, I find out is CF_SQL_BLOB doesn't support, but I can't find the replayment for that. Can any one help me. Thanks in advances.
acoder 16,027
Recognized Expert Moderator MVP
Do you get any errors?
I've noticed one thing. You've uploaded to the Uploads directory, but attempting to read the file from the temp directory.
Do you get any errors?
I've noticed one thing. You've uploaded to the Uploads directory, but attempting to read the file from the temp directory.
Hi,
Thanks for reponding,
1) yes I do have an error on:
cfsqltype="cf_s ql_blob" and stop there.
2) You right, suppost to c:\Upload\ for both location
Right now I am change my dirrect because it is taking too long, I can not find any one can help me with this.
What I am doing now is:
* Create a folder on the server
* Provide the user to upload any file from local drive to the server Directory folder
* Save the file name into Access
* Provide the link to that file and view
I am still interest in Blob (cfsqltype="cf_ sql_blob"), if any one can help me out, very appreciated.
Regards,
acoder 16,027
Recognized Expert Moderator MVP
Right now I am change my dirrect because it is taking too long, I can not find any one can help me with this.
What I am doing now is:
* Create a folder on the server
* Provide the user to upload any file from local drive to the server Directory folder
* Save the file name into Access
* Provide the link to that file and view
That's a good workaround.
I am still interest in Blob (cfsqltype="cf_ sql_blob"), if any one can help me out, very appreciated.
Regards,
In Coldfusion Administrator, check the settings for the database under Data Sources. Edit the data source and click on Advanced Settings. There should be a checkbox for enabling BLOB and CLOB.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: weiwei |
last post by:
Hi All
I want to upload either image or word document into either access or
SQL server database
so far I am doing some small testings and what I can do is upload the
file from first page and display at the next
page with (both image or word are working fine).
however, I cann't insert them into the database, Plus, what type
should I use in access database?
anyone who has this type of project, please help me out
below is my current test...
|
by: Codeman II |
last post by:
Hi there,
I am building a form where the user must upload a picture and fill in his
details.
Now I have a problem as all of this is on the same form.
How will I be able to have the Browse button to open the "file browse"
dialog
and the Submit button to submit the form data.
|
by: Nathan Sokalski |
last post by:
I have a form that allows the user to upload a file. Even though <input
type="file" runat="server"> is intended to have the user choose the file
using the browse button, it still allows them to change the path before it
is uploaded. I currently use the following code to upload the file:
Dim upfilename As String = ""
If fileDetails.Value <> "" Then
Dim dir As String() =
fileDetails.PostedFile.FileName.Split("\".ToCharArray())
|
by: Seok Bee |
last post by:
Dear Experts,
I currently trying to use the FileUpload control from asp.net 2.0 to upload
files. The uploading of the file I would like to store it in the Access
Database. Unfortunately, I've no idea how I can do that. Can anyone provide
me some solution by writing the code in vb.net?
Many thanks in advance.
Regards,
|
by: Jim Michaels |
last post by:
after a file upload, $_FILES is not populated but $_POST is. what's going
on here?
$_POST=C
$_POST=C
$_POST=C
$_POST=C:\\www\\jimm\\images\\bg1.jpg
$_FILES=
$_FILES=
$_FILES=
| |
by: sumaabey |
last post by:
my code
<?
//include("../mysqlconnect.php");
$link = mysql_connect("localhost","root","")
or die("Could not connect: " . mysql_error());
mysql_select_db("suma");
include("include/upload.inc.php");
if(isset($_POST))
{
|
by: siyaverma |
last post by:
i am trying to upload csv file from user's computer to main server
the code i am using is
if(((isset($_GET)) && ($_GET=="yes")) )
{
$typefield = $_GET;
echo "<form enctype=\"multipart/form-data\" action=\"$PHP_SELF\" method=\"POST\">
|
by: Jacotheron |
last post by:
I need a PHP script that can upload music files (mp3). The script is for a home project I have started a while ago. I have a MySQL database of all the music that I have. Other computers on the network should be able to connect to the database and run queries on the database or upload new music that does not yet exist on the database. The uploaded file's name should be in the following format: ARTIST - TITLE.mp3. I have the code to upload images,...
|
by: =?ISO-8859-1?B?UOlw6g==?= |
last post by:
Hi all.
Im a newbie in PHP and im trying to upload a file to the server.
I use a form to upload a pdf file and some text information about it.
The client uploads the file and the system renames that file and puts
all the information in the database.
The problem is when the client goes again to edit the information, i
|
by: ririe |
last post by:
Hi. I have a problem here. I want to upload a file together with its semester. So I create two field. One for the semester and one for the file to be uploaded. But the script doesn't work. I don't know why. However, if I try to upload the file without the semester field, the script is working. May be the problem comes from the semester field. This is my codes.
Form.php
?><?php require_once('Connections/connection.php'); ?><?php
if...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |