Hello, I have a question about CFspreadsheet.... I'm reading a spreadsheet and inserting the data into a SQL server DB....everything works fine unless 1 of my columns in the spreadsheet is blank. I'm getting the following error:
Element PHONE is undefined in EXCELQUERYBYNAME. I tried the put a cfif isdefined to see if that would solve it but no luck....same error message. How can I handle this issue? My cfquery is below: <cfquery name="insert_Sh_data" datasource="#datasource#"> INSERT into contactrecord ( contact_date, fname, lname, address, city, state, zip, county, <cfif isDefined(excelQueryByName.phone)>phone,</cfif> <cfif isDefined(excelQueryByName.cell)>cell,</cfif> <cfif isDefined(excelQueryByName.fax)>fax,</cfif> <cfif isDefined(excelQueryByName.title)>title,</cfif> <cfif isDefined(excelQueryByName.organization)>organization,</cfif> <cfif isDefined(excelQueryByName.email)>email,</cfif> <cfif isDefined(excelQueryByName.general_comments)>general_comments,</cfif> <cfif isDefined(excelQueryByName.fname2)>fname2,</cfif> <cfif isDefined(excelQueryByName.lname2)>lname2,</cfif> mailing, input_by, input_date, input_time, input_by_id, country, sh_rating ) Values( '#Trim(excelQueryByName.contact_date)#', '#Trim(excelQueryByName.fname)#', '#Trim(excelQueryByName.lname)#', '#Trim(excelQueryByName.address)#', 'Trim(excelQueryByName.city)#', '#Trim(excelQueryByName.state)#', '#Trim(excelQueryByName.zip)#', '#Trim(excelQueryByName.county)#', <cfif isDefined(excelQueryByName.phone)>'#Trim(excelQueryByName.phone)#',</cfif> <cfif isDefined(excelQueryByName.cell)>'#Trim(excelQueryByName.cell)#',</cfif> <cfif isDefined(excelQueryByName.fax)>'#Trim(excelQueryByName.fax)#',</cfif> <cfif isDefined(excelQueryByName.title)>'#Trim(excelQueryByName.title)#',</cfif> <cfif isDefined(excelQueryByName.organization)>'#Trim(excelQueryByName.organization)#',</cfif> <cfif isDefined(excelQueryByName.email)>'#Trim(excelQueryByName.email)#',</cfif> <cfif isDefined(excelQueryByName.general_comments)>'#Trim(excelQueryByName.general_comments)#',</cfif> <cfif isDefined(excelQueryByName.fname2)>'#Trim(excelQueryByName.fname2)#',</cfif> <cfif isDefined(excelQueryByName.lname2)>'#Trim(excelQueryByName.lname2)#',</cfif> '#Trim(excelQueryByName.mailing)#', '#Trim(excelQueryByName.input_by)#', '#Trim(excelQueryByName.input_date)#', '#Trim(excelQueryByName.input_time)#', '#Trim(excelQueryByName.input_by_id)#', '#Trim(excelQueryByName.country)#', '#Trim(excelQueryByName.sh_rating)#' ) </cfquery> Thanks in Advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm