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

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

ShwapyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

erikTsomikSystem Architect, CF programmer Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShwapyAuthor Commented:
Thanks for your help!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.