Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
sartis
Author: steve artis
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:64108#352117
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 column 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.
|
May 19, 2013
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
