Try this lee. <!--- Upload File Attachment, check if user has selected a file first ---> <cfif Len(Trim(form.file_rfq)) GT 0> <CFFILE action="UPLOAD" FILEFIELD="file_rfq" DESTINATION="d:\webserver\mysite\www\uploads\" NAMECONFLICT="makeunique"> <cfset uploadedfilename = CFFILE.SERVERFILE> <cfelse> <cfset uploadedfilename = ""> </cfif> <!--- End Insert --->
<!--- SQL Insert Statement - After Upload & If user selected a file to upload ---> <CFQUERY DATASOURCE="datasourcename"> INSERT INTO rfqs(rfq_fullname, rfq_companyname, rfq_email, rfq_tel, project_name, project_scope, budget, timescale, file_rfq) VALUES('#Trim(FORM.rfq_fullname)#', '#Trim(FORM.rfq_companyname)#', '#Trim(FORM.rfq_email)#', '#Trim(FORM.rfq_tel)#', '#Trim(FORM.project_name)#', '#Trim(FORM.project_scope)#', '#Trim(FORM.budget)#', '#Trim(FORM.timescale)#', '#Trim(uploadedfilename)#') </CFQUERY> -----Original Message----- From: Lee Bailey - Element2 Limited [mailto:[EMAIL PROTECTED]] Sent: 25 October 2001 11:39 To: CF-Talk Subject: Problem with database insert Hi all, I have a form which includes a file field, however this is an optional field for the user. The 'insert.cfm' page checks to see if the user has selected a file and if so gets the name of it and all the other form data and inserts it into a database. The problem I'm having is what code I need to use as an 'else' (if the user hasn't selected a file to upload) - everything I've tried so far is giving me an access violation. Code for the 'insert.cfm' page is below....any help would really be appreciated! Thanks, Lee <!--- Upload File Attachment, check if user has selected a file first ---> <cfif Len(Trim(form.file_rfq)) GT 0> <CFFILE action="UPLOAD" FILEFIELD="file_rfq" DESTINATION="d:\webserver\mysite\www\uploads\" NAMECONFLICT="makeunique"> </cfif> <!--- End Insert ---> <!--- SQL Insert Statement - After Upload & If user selected a file to upload ---> <cfif Len(Trim(form.file_rfq)) is not 0> <CFQUERY DATASOURCE="datasourcename"> INSERT INTO rfqs(rfq_fullname, rfq_companyname, rfq_email, rfq_tel, project_name, project_scope, budget, timescale, file_rfq) VALUES('#Trim(FORM.rfq_fullname)#', '#Trim(FORM.rfq_companyname)#', '#Trim(FORM.rfq_email)#', '#Trim(FORM.rfq_tel)#', '#Trim(FORM.project_name)#', '#Trim(FORM.project_scope)#', '#Trim(FORM.budget)#', '#Trim(FORM.timescale)#', '#Trim(CFFILE.SERVERFILE)#') </CFQUERY> </cfif> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists