Solved

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

Posted on 2009-07-07
2
203 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
Comment Utility
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
Comment Utility
Thanks for your help!!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
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 …
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now