sartis

[steve artis]

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. 


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:352117
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm