Solved

How do I get my form to submit if file upload field is left blank?

Posted on 2009-07-07
2
209 Views
Last Modified: 2013-12-24
Hi folks, this is probably an easy one Im fairly new to CF.  I have a simple form for the user to fill out.  I added two file upload fields to the form that will store the file in a directory on the server and store the absolute path in the database.  Everything works fine when files are uploaded but when the user skips uploading a file the page will not go through. (This will not be a mandatory field) Im getting the error VARIABLE FULLFILEPATH IS UNDEFINED.

I added <cfif (form.agenda) NEQ ""> for the code to move on if there is no file to be uploaded but its getting hung up on <cfset FullFilePath="http://########item/#CFFILE.ServerFilename#.#CFFILE.ServerFileExt#">

I hope Im explaining this ok.  Any help would be appreciated.  

<cfif form.operation IS "Submit">
 
<cfset destination=GetDirectoryFromPath(CGI.PATH_TRANSLATED) & "docs\">
<cfif (form.agenda) NEQ "">
<cffile
	action="upload"
	filefield="agenda"
	destination=#destination#"
	nameconflict='makeunique">
 
<cfset FullFilePath="http://########docs/#CFFILE.ServerFilename#.#CFFILE.ServerFileExt#">
</cfif>
 
 
<cfset destination=GetDirectoryFromPath(CGI.PATH_TRANSLATED) & "item\">
<cfif (form.item) NEQ "">
<cffile
	action="upload"
	filefield="item"
	destination=#destination#"
	nameconflict='makeunique">
 
<cfset FullFilePath1="http://########item/#CFFILE.ServerFilename#.#CFFILE.ServerFileExt#">
</cfif>
 
	<cfquery name="submit_kc" datasource="#DS#">
	insert into
#kch#(office,classification,title,day,month,year,location,participants,purpose,agenda,item)
	values('#form.office#',
		'#form.classification#',
		'#trim(form.title)#',
		'#form.day#',
		'#form.month#',
		'#form.year#',
		'#trim(form.location)#',
		'#trim(form.participants)#',
		'#trim(form.purpose)#',
		'#FullFilePath#',
		'#FullFilePath1#'
)
</cfquery>
</cfif>

Open in new window

0
Comment
Question by:Shwapy
2 Comments
 
LVL 19

Accepted Solution

by:
erikTsomik earned 500 total points
ID: 24795881
ok I believe the problem is here
If you do not upload anything you should not have insert anything into the dataabse

SO just do this
<cfquery name="submit_kc" datasource="#DS#">
        insert into
#kch#(office,classification,title,day,month,year,location,participants,purpose<cfif agenda neq "">,agenda</cfif>,<cfif form.Item neq "">item</cfif>)
        values('#form.office#',
                '#form.classification#',
                '#trim(form.title)#',
                '#form.day#',
                '#form.month#',
                '#form.year#',
                '#trim(form.location)#',
                '#trim(form.participants)#',
                '#trim(form.purpose)#'
<cfif form.agenda neq "">
                ,'#FullFilePath#',
</CFIF>
<CFIF FORM.item neq "">
                '#FullFilePath1#'

</cfif>
)
</cfquery>

That will soleve the problem.
Also get to the habit of using <cfqueryparam
0
 

Author Closing Comment

by:Shwapy
ID: 31600674
Thanks for your help!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question