Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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

0
Shwapy
Asked:
Shwapy
1 Solution
 
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
 
ShwapyAuthor Commented:
Thanks for your help!!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now