CFspreadsheet issue

hello, have question cfspreadsheet....

 

 

i'm reading spreadsheet , inserting data into  sql server  db....everything works fine unless 1 of columns in spreadsheet blank. i'm getting following error:

 

 

element phone undefined in excelquerybyname.

 

 

i tried put cfif isdefined see if solve no luck....same error message. how can handle issue? cfquery below:

 

 

<cfquery name="insert_sh_data" datasource="#datasource#">

    insert 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.

instead of checking see if field defined, check see if length greater 0.

More discussions in ColdFusion

adobe