Link to home
Start Free TrialLog in
Avatar of koila
koilaFlag for Australia

asked on

What this coldfusion error means?

Any idea what this error mean.  It was working on my previous hosting now it's not working.

Error Occurred While Processing Request  


Attribute validation error for tag file.
 
 The tag does not have an attribute called username. The valid attribute(s) are action, charset, accept, destination, filefield, nameconflict, mode, attributes, source, file, variable, output, addnewline.  
 
ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem.  
 

 
 Please try the following: •Check the ColdFusion documentation to verify that you are using the correct syntax.
•Search the Knowledge Base to find a solution to your problem.


 

Browser   Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko
Remote Address   173.239.154.235
Referrer   http://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Date/Time   12-Jun-14 01:07 PM
 

 Stack Trace  


coldfusion.compiler.TagAttributeNotFoundException: Attribute validation error for tag file.
      at coldfusion.compiler.TagNode.getAttributeInfo(TagNode.java:244)
      at coldfusion.compiler.StmtAssembler.emitSetter(StmtAssembler.java:1038)
      at coldfusion.compiler.StmtAssembler.setAttributes(StmtAssembler.java:866)
      at coldfusion.compiler.StmtAssembler.cftag(StmtAssembler.java:594)
      at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:296)
      at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:213)
      at coldfusion.compiler.StmtAssembler.block(StmtAssembler.java:193)
      at coldfusion.compiler.StmtAssembler.cfif(StmtAssembler.java:1973)
      at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:234)
      at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:213)
      at coldfusion.compiler.StmtAssembler.block(StmtAssembler.java:193)
      at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:214)
      at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:213)
      at coldfusion.compiler.StmtAssembler.cfif(StmtAssembler.java:1980)
      at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:234)
      at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:213)
      at coldfusion.compiler.StmtAssembler.block(StmtAssembler.java:193)
      at coldfusion.compiler.StmtAssembler.createFactoredMethod(StmtAssembler.java:413)
      at coldfusion.compiler.StmtAssembler.factoredNode(StmtAssembler.java:371)
      at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:310)
      at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:213)
      at coldfusion.compiler.StmtAssembler.block(StmtAssembler.java:189)
      at coldfusion.compiler.TemplateAssembler.assemblePage(TemplateAssembler.java:175)
      at coldfusion.compiler.TemplateAssembler.assemble(TemplateAssembler.java:58)
      at coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:265)
      at coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:97)
      at coldfusion.runtime.TemplateClassLoader$1.fetch(TemplateClassLoader.java:263)
      at coldfusion.util.LruCache.get(LruCache.java:188)
      at coldfusion.runtime.TemplateClassLoader$TemplateCache.fetchSerial(TemplateClassLoader.java:214)
      at coldfusion.util.AbstractCache.fetch(AbstractCache.java:58)
      at coldfusion.util.SoftCache.get(SoftCache.java:81)
      at coldfusion.runtime.TemplateClassLoader.findClass(TemplateClassLoader.java:356)
      at coldfusion.filter.PathFilter.invoke(PathFilter.java:73)
      at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
      at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
      at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
      at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
      at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
      at coldfusion.CfmServlet.service(CfmServlet.java:105)
      at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
      at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
      at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
      at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
      at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
      at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
      at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
      at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
      at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Avatar of Randy Johnson
Randy Johnson
Flag of United States of America image

IT means you are trying to passing the argument of username to the <CF tag and it doesn't like it.  remove username="xxx" from the arguments and you should be good to go.
Avatar of koila

ASKER

so this is my actual code.

<cfset Variables.USERNAME="xxxxxx">
<cfset Variables.PASSWORD="xxxxxxx">

so the username and password was wrong I've change to the new one. and it didn't work?
Well This error:

The tag does not have an attribute called username. The valid attribute(s) are action, charset, accept, destination, filefield, nameconflict, mode, attributes, source, file, variable, output, addnewline.  

is coming from another tag.  IT looks like a cffile upload perhaps?
Avatar of _agx_
(Edit: Took too long writing this and didn't see the recent comments)

>  The tag does not have an attribute called username.

Like @rjohnsonjr and the error message says, you're adding a "username" attribute where it doesn't belong.  

We need to see your code, but the error message suggests a <cffile> tag is involved. You'd get the same error if you tried to do this:

         <!--- this will NOT work --->
         <cffile action="read" file="c:/path/someFile.txt"
                     variable="content"
                     username="#variables.userName#">

... because the <cffile> tag doesn't have a "username" attribute.

Post your code an we can help you fix it.
Avatar of koila

ASKER

I've copied the full code but please note that I've replace the username and the password with xxxx

--------------------
<CFQUERY NAME="Applicants" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity
      WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID)
     ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
      </CFQUERY>
   
<CFQUERY NAME="cvitool" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM cvitool
</CFQUERY>
   
<CFQUERY NAME="Cttee" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT name_e, cttee_code
    FROM  cttee_codes_tors, cttee_activity
    WHERE (cttee_activity.other_code = cttee_codes_tors.cttee_code) AND (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#')
      </CFQUERY>

<CFQUERY NAME="Applicants2" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity
      WHERE (CTTEE_ACTIVITY.OTHER_CODE = 'ANY') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID)
    ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
</CFQUERY>

<cfset username ="xxxx-ftp">
<cfset password = "xxxxxxx">


<!--- this was my previous code on the old hosting
<cfset Variables.USERNAME="xxxxx">
<cfset Variables.PASSWORD="xxxxxxx">--->


<cfset ApplicantLIST=ValueList(Applicants.ref_id)>
<cfset ApplicantLIST2=ValueList(Applicants2.ref_id)>
<cfset CompleteList=ListAppend(ApplicantLIST, ApplicantLIST2)>

<CFQUERY NAME="Committee" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE  (ENROLLEES.REF_ID in (#CompleteList#)) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_CODE) AND (CTTEE_ACTIVITY.ACTION_CODES = CTTEE_POSITIONS.POSITION_CODE)
</CFQUERY>

<!-- Export Tool -->      
<cfparam name="Task" default="">  
<cfif Task eq "ExportInfo">
      <CFQUERY NAME="Export" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity, cvitool
      WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CVITOOL.ID)
     ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
</CFQUERY>

      <cfscript>
      /**
       * Fixes text using Microsoft Latin-1 &quot;Extentions&quot;, namely ASCII characters 128-160.
       *
       * @param text        Text to be modified. (Required)
       * @return Returns a string.
       * @author Shawn Porter (sporter@rit.net)
       * @version 1, June 16, 2004
       */
      function DeMoronize (text) {
            var i = 0;
      
          // map incompatible non-ISO characters into plausible
            // substitutes
            text = Replace(text, Chr(128), "&euro;", "All");
      
            text = Replace(text, Chr(130), ",", "All");
            text = Replace(text, Chr(131), "<em>f</em>", "All");
            text = Replace(text, Chr(132), ",,", "All");
            text = Replace(text, Chr(133), "...", "All");
                  
            text = Replace(text, Chr(136), "^", "All");
      
            text = Replace(text, Chr(139), ")", "All");
            text = Replace(text, Chr(140), "Oe", "All");
      
            text = Replace(text, Chr(145), "'", "All");
            text = Replace(text, Chr(146), "'", "All");
            text = Replace(text, Chr(147), "'", "All");
            text = Replace(text, Chr(148), "'", "All");
            text = Replace(text, Chr(149), "*", "All");
            text = Replace(text, Chr(150), "-", "All");
            text = Replace(text, Chr(151), "--", "All");
            text = Replace(text, Chr(152), "~", "All");
            text = Replace(text, Chr(153), "&trade;", "All");
      
            text = Replace(text, Chr(155), ")", "All");
            text = Replace(text, Chr(156), "oe", "All");
      
            // remove any remaining ASCII 128-159 characters
            for (i = 128; i LTE 159; i = i + 1)
                  text = Replace(text, Chr(i), "", "All");
      
            // map Latin-1 supplemental characters into
            // their &name; encoded substitutes
            text = Replace(text, Chr(160), "&nbsp;", "All");
      
            text = Replace(text, Chr(163), "&pound;", "All");
      
            text = Replace(text, Chr(169), "&copy;", "All");
      
            text = Replace(text, Chr(176), "&deg;", "All");
      
            // encode ASCII 160-255 using ? format
            for (i = 160; i LTE 255; i = i + 1)
                  text = REReplace(text, "(#Chr(i)#)", "&###i#;", "All");
            
          // supply missing semicolon at end of numeric entities
            text = ReReplace(text, "&##([0-2][[:digit:]]{2})([^;])", "&##\1;\2", "All");
            
          // fix obscure numeric rendering of &lt; &gt; &amp;
            text = ReReplace(text, "&##038;", "&amp;", "All");
            text = ReReplace(text, "&##060;", "&lt;", "All");
            text = ReReplace(text, "&##062;", "&gt;", "All");
      
            // supply missing semicolon at the end of &amp; &quot;
            text = ReReplace(text, "&amp(^;)", "&amp;\1", "All");
            text = ReReplace(text, "&quot(^;)", "&quot;\1", "All");
      
            return text;
      }
      </cfscript>


      <CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>

      <cfif Applicants.RecordCount gt 0>
            <cfoutput query="Export">
                  <CFQUERY NAME="Comm_Applicant" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
                  SELECT *
                  FROM cttee_activity
                  WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'Applicant')
                  </CFQUERY>
                  
                  <CFQUERY NAME="Comm_Sitting" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
                  SELECT *
                  FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
                  WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_CODE) AND (CTTEE_ACTIVITY.ACTION_CODES = CTTEE_POSITIONS.POSITION_CODE)
                  </CFQUERY>
            
            
                  <CFIF #Export.enrollee_type# EQ "FL" or #Export.enrollee_type# EQ "FLX">
                        <cfset year_mem_status = "#Export.fcia_yr#">
                  <CFELSE>
                <CFIF #Export.enrollee_type# EQ "S2" or #Export.enrollee_type# EQ "S2X" or #Export.enrollee_type# EQ "S2T" or #Export.enrollee_type# EQ "S2TX">
                              <cfset year_mem_status = "#Export.st_yr#">
                <CFELSE>
                      <CFIF #Export.enrollee_type# EQ "AF" or #Export.enrollee_type# EQ "AFX">
                                    <cfset year_mem_status = "#cvitool.af_yr#">
                      <CFELSE>
                            <CFIF #Export.enrollee_type# EQ "CR" or #Export.enrollee_type# EQ "CRX">
                                          <cfset year_mem_status = "#cvitool.cr_yr#">
                            </CFIF>                
                      </CFIF>          
                  </CFIF>
              </CFIF>
                  
                  <!---loop through committies that have been applied to--->
                  <cfset comm_applied_to = "">
                  <cfloop query="Comm_Applicant">
                        <cfset comm_applied_to = ListAppend(comm_applied_to, Comm_Applicant.description)>
                  </cfloop>
                  
                  <!---looop through committies that member is sitting--->
                  <cfset comm_sitting_to = "">
                  <cfloop query="Comm_Sitting">
                        <cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
                  </cfloop>
            
                  <CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
            </cfoutput>
      </cfif>
<cfelse>
      <cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
              <CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
      </cfif>
</cfif>

<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>CVI Tools - Member(s) Details</title>

<!-- Script expand -->
<script>
function toggle(id){
  var element = document.getElementById(id);
  element.style.display = (element.style.display == 'block') ? "none" : "block";
  }
</script>

<!-- Script pop-up window -->
<script type="text/javascript">
    var GB_ROOT_DIR = "..common/greybox/";
</script>
<script type="text/javascript" src="../common/greybox/AJS.js"></script>
<script type="text/javascript" src="../common/greybox/AJS_fx.js"></script>
<script type="text/javascript" src="../common/greybox/gb_scripts.js"></script>
<link href="../common/greybox/gb_styles.css" rel="stylesheet" type="text/css" />
<link href="../common/applicant.css" rel="stylesheet" type="text/css">
</head>

<BODY>

<div id="main">  

    <a name="top"></a>
    <div align="center"><br>
  <img src="../images/print-logo.gif" alt="CIA Logo ICA" width="208" height="71"><br></div>
  <div class="title">
    <img src="../images/comment.png" alt="Info" width="24" height="24" align="absmiddle">&nbsp;There are <cfoutput>#APPLICANTS.RECORDCOUNT# applicants for the #CTTEE.NAME_E#</cfoutput>
    </div>
 
<CFLOOP QUERY="APPLICANTS">
<CFOUTPUT>
<hr size="2" color="##ccc">
    <div class="content01">
        <div class="box01">First Name</div>
        <div class="box02">#Applicants.enrollee_firstname#</div>
        <div class="box05">Company</div>
        <div class="box06"><CFIF #Applicants.company# NEQ "">#Applicants.company#<cfelse>Not Available</CFIF></div>
        <br>
        <div class="box03">Last Name</div>
        <div class="box04">#Applicants.enrollee_lastname#</div>      
    </div>
    <!-- Additional Contact Details -->
    <div class="add">
    <a href="javascript: toggle(22#id#123);"><img src="../images/bulletin-arrow.gif" alt="More information" align="absmiddle" border="0">&nbsp;Additional Contact Details</a><br>
        <div  id="22#id#123" style="display: none">
          <div class="addcontent01">
            <div class="box01">Job Title</div>
            <div class="box02">#Applicants.title#</div>
            <div class="box05">Fax</div>
            <div class="box06">#Applicants.fax#</div>
            <br>
            <div class="box03">Province of Residence</div>
            <div class="box04">#Applicants.state_province#</div>
            <div class="box05">Email Address</div>
            <div class="box06">#Applicants.official_email#</div>
            <br>
            <div class="box03">Phone</div>
            <div class="box04">#Applicants.work_phone#</div>
            <br><br>
               </div>
        </div>
    </div>
      <!-- End of Additional Contact Details -->
   
   
      <div class="content02">
        <div class="box01">Primary Practice Area*</div>
        <div class="box02"><cfif #Applicants.prim_prac_area# NEQ "">#Applicants.prim_prac_area#<cfelse>N/A</cfif></div>
        <div class="box05">Year of Achieving Membership Status</div>
        <div class="box06">                
            <CFIF #Applicants.enrollee_type# EQ "FL" or #Applicants.enrollee_type# EQ "FLX">&nbsp;#Applicants.fcia_yr# <cfset year_achieving = "#Applicants.fcia_yr#">
<CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "S2" or #Applicants.enrollee_type# EQ "S2X" or #Applicants.enrollee_type# EQ "S2T" or #Applicants.enrollee_type# EQ "S2TX">&nbsp;#Applicants.st_yr# <cfset year_achieving = "#Applicants.st_yr#">
                <CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "AF" or #Applicants.enrollee_type# EQ "AFX">&nbsp;#cvitool.af_yr# <cfset year_achieving = "#cvitool.af_yr#">
                <CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "CR" or #Applicants.enrollee_type# EQ "CRX">&nbsp;#cvitool.cr_yr# <cfset year_achieving = "#cvitool.cr_yr#">
                </CFIF>                
                </CFIF>          
                  </CFIF>
        </CFIF>
        </div>
        <br>
        <div class="box03">Membership Status</div>
        <div class="box04">#Applicants.enrollee_type#</div>
      </div>
    <div class="add">
    <!-- Practice Area Details -->
      <a href="javascript: toggle(11#id#321);"><img src="../images/bulletin-arrow.gif" alt="More information" width="9" height="11" align="absmiddle" border="0">&nbsp;Practice Area Details</a><br>
        <div  id="11#id#321" style="display:none">
            <div class="addcontent02">
            <div class="box01">Primary Sub Category*</div>
            <div class="box02">#Applicants.prim_sub_area#</div>
            <div class="box05">Major Job Function*</div>
            <div class="box06">#Applicants.major_job_function#</div>            
            <div class="box03">Employer Type*</div>
            <div class="box04">#Applicants.employer_type_new#</div>
          </div>
        </div>
    </div>
    <!-- End of Practice Area Details -->

      <!-- BUTTONS -->
      <div class="content03">
        <div class="buttons">
            <a href="/members/volunteer_profile.cfm?ID=#id#&OTHER_CODE=#OTHER_CODE#" onClick="return GB_showFullScreen('Volunteer Profile', this.href)" class="regular"><img src="../images/add.png" alt="Profile" width="48" height="48">Additional Profile</a>
            <a href="/members/employment_codes.cfm" onClick="return GB_showFullScreen('List of codes', this.href)" class="regular"><img src="../images/comment.png" alt="Info" width="48" height="48">*Practice Area codes</a>
            <a href="Toolkit/Remove_confirm.cfm?Lang=E&ID=#Applicants.ID#&OTHER_CODE=#OTHER_CODE#&NAME=        #Applicants.prefix# #Applicants.enrollee_firstname# #Applicants.enrollee_middlename# #Applicants.enrollee_lastname#&Task=Confirm" onClick="return GB_showCenter('Remove this person as an applicant for this committee ', this.href)" class="regular"><img src="../images/delete.png" alt="Delete" width="48" height="48">Remove this person</a>
            <!-- Export tool -->
            <a href="03_applicant_list_e.cfm?OTHER_CODE=#OTHER_CODE#&Task=ExportInfo" class="regular"><img src="../images/upload.png" alt="Export the Comittee information" width="48" height="48">Export to file</a>
            <a href="/members/cvi_search.cfm" class="regular" target="_blanc"><img src="../images/Search.png" alt="Search Tool" width="32" height="32">Search the Registry</a>        
            <a href="##top" class="regular"><img src="../images/home.png" alt="Back to the top" width="48" height="48">Back to the top</a>
            </div>
    </div>
            <!-- Export tool -->
                  <cfif Task eq "ExportInfo">
            <div class="content04">
            Right-click on the link below and select <strong>"Save Target As..."</strong> to save this file to your local computer: <a href="/members/toolkit/export/#OTHER_CODE#_cttee.csv" target="_blank"><strong>#OTHER_CODE#_cttee.csv</strong></a></div>
            </cfif>
               
    <!-- END of BUTTONS -->  
</cfoutput>
</CFLOOP>
</div>
</BODY>
</HTML>
>  <CFFILE username="#Variables.USERNAME#"
password="#Variables.PASSWORD#"
ACTION="DELETE"
> ....

CFFile doesn't have a username attribute.  As suggested, just remove username and password from that tag and it should work.

        <CFFILE ACTION="DELETE" ....>
Avatar of koila

ASKER

hello AGX

the error is in this part for sure.

<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
		  <CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

Open in new window

yea this code right here has a username in it.. That is the problem I think.

  <cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
              <CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
      </cfif>

Open in new window

Avatar of koila

ASKER

I did the following changes.  I've remove the username and password on all CFX_SFILE and CFFILE

<!---
<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>
--->

	<CFX_SFILE action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>

Open in new window

and this one.
<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
	<!---<CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>--->
    	  <CFFILE ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

Open in new window


As you know before on my others page,
<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
		  <CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

Open in new window

Did that eliminate the errors?
Avatar of koila

ASKER

here is an image of the errors
User generated image
<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
		  <CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

Open in new window

<!---
<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>
--->

	<CFX_SFILE action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>

Open in new window

<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
	<!---<CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>--->
    	  <CFFILE ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

Open in new window

Avatar of koila

ASKER

no it didn't I still getting the errors.  I really appreciate your help. please advise.  I will copy the full code now.
Avatar of koila

ASKER

I've replaced the actual username and password with XXX

<CFQUERY NAME="Applicants" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity
	WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID)
     ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
	</CFQUERY>
    
<CFQUERY NAME="cvitool" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM cvitool
</CFQUERY>
    
<CFQUERY NAME="Cttee" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT name_e, cttee_code
    FROM  cttee_codes_tors, cttee_activity
    WHERE (cttee_activity.other_code = cttee_codes_tors.cttee_code) AND (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#')
	</CFQUERY>

<CFQUERY NAME="Applicants2" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity
	WHERE (CTTEE_ACTIVITY.OTHER_CODE = 'ANY') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID)
    ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
</CFQUERY>

<cfset username ="xxxxx">
<cfset password = "xxxxx">


<!---
<cfset Variables.USERNAME="xxxxxx">
<cfset Variables.PASSWORD="xxxxxx">--->

<!---<cfset username ="xxxxxx">
<cfset password = "xxxxx">--->

<cfset ApplicantLIST=ValueList(Applicants.ref_id)>
<cfset ApplicantLIST2=ValueList(Applicants2.ref_id)>
<cfset CompleteList=ListAppend(ApplicantLIST, ApplicantLIST2)>

<CFQUERY NAME="Committee" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE  (ENROLLEES.REF_ID in (#CompleteList#)) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_CODE) AND (CTTEE_ACTIVITY.ACTION_CODES = CTTEE_POSITIONS.POSITION_CODE)
</CFQUERY>

<!-- Export Tool -->      
<cfparam name="Task" default="">   
<cfif Task eq "ExportInfo">
	<CFQUERY NAME="Export" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
    SELECT *
    FROM enrollees, cttee_activity, cvitool
	WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CVITOOL.ID)
     ORDER BY enrollees.enrollee_lastname, enrollees.enrollee_firstname
</CFQUERY>

	<cfscript>
	/**
	 * Fixes text using Microsoft Latin-1 &quot;Extentions&quot;, namely ASCII characters 128-160.
	 * 
	 * @param text 	 Text to be modified. (Required)
	 * @return Returns a string. 
	 * @author Shawn Porter (sporter@rit.net) 
	 * @version 1, June 16, 2004 
	 */
	function DeMoronize (text) {
		var i = 0;
	
	    // map incompatible non-ISO characters into plausible 
		// substitutes
		text = Replace(text, Chr(128), "&euro;", "All");
	
		text = Replace(text, Chr(130), ",", "All");
		text = Replace(text, Chr(131), "<em>f</em>", "All");
		text = Replace(text, Chr(132), ",,", "All");
		text = Replace(text, Chr(133), "...", "All");
			
		text = Replace(text, Chr(136), "^", "All");
	
		text = Replace(text, Chr(139), ")", "All");
		text = Replace(text, Chr(140), "Oe", "All");
	
		text = Replace(text, Chr(145), "'", "All");
		text = Replace(text, Chr(146), "'", "All");
		text = Replace(text, Chr(147), "'", "All");
		text = Replace(text, Chr(148), "'", "All");
		text = Replace(text, Chr(149), "*", "All");
		text = Replace(text, Chr(150), "-", "All");
		text = Replace(text, Chr(151), "--", "All");
		text = Replace(text, Chr(152), "~", "All");
		text = Replace(text, Chr(153), "&trade;", "All");
	
		text = Replace(text, Chr(155), ")", "All");
		text = Replace(text, Chr(156), "oe", "All");
	
		// remove any remaining ASCII 128-159 characters
		for (i = 128; i LTE 159; i = i + 1)
			text = Replace(text, Chr(i), "", "All");
	
		// map Latin-1 supplemental characters into
		// their &name; encoded substitutes
		text = Replace(text, Chr(160), "&nbsp;", "All");
	
		text = Replace(text, Chr(163), "&pound;", "All");
	
		text = Replace(text, Chr(169), "&copy;", "All");
	
		text = Replace(text, Chr(176), "&deg;", "All");
	
		// encode ASCII 160-255 using ? format
		for (i = 160; i LTE 255; i = i + 1)
			text = REReplace(text, "(#Chr(i)#)", "&###i#;", "All");
		
	    // supply missing semicolon at end of numeric entities
		text = ReReplace(text, "&##([0-2][[:digit:]]{2})([^;])", "&##\1;\2", "All");
		
	    // fix obscure numeric rendering of &lt; &gt; &amp;
		text = ReReplace(text, "&##038;", "&amp;", "All");
		text = ReReplace(text, "&##060;", "&lt;", "All");
		text = ReReplace(text, "&##062;", "&gt;", "All");
	
		// supply missing semicolon at the end of &amp; &quot;
		text = ReReplace(text, "&amp(^;)", "&amp;\1", "All");
		text = ReReplace(text, "&quot(^;)", "&quot;\1", "All");
	
		return text;
	}
	</cfscript>

<!---
<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>
--->

	<CFX_SFILE action="write" nameconflict="OVERWRITE" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,Phone,Primary Practice Area,Year of Achieving Membership Status, Membership Status,Primary Sub Category,Employer Type,Major Job Function,Date Volunteer Profile was Last Updated,Members Preferrred Committee Type,CIA Issues of Interest to the Member,Members Practice Area Specialization,Members Years of Experience,Members Prior Work History,Members Other Volunteer Work History (Actuarial),Members Other Volunteer Work History (Non-Actuarial),Members Special Interests,Members Special Skills,Committees on Which the Member has Applied,Committees on Which the Member is Currently Serving'>

	<cfif Applicants.RecordCount gt 0>
		<cfoutput query="Export">
			<CFQUERY NAME="Comm_Applicant" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
			SELECT *
			FROM cttee_activity
			WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'Applicant')
			</CFQUERY>
			
			<CFQUERY NAME="Comm_Sitting" datasource="#application.datasource#" username="#application.username#" password="#application.password#">
			SELECT *
			FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
			WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (ENROLLEES.ENROLLEE_ID_NUMBER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_TYPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_CODE) AND (CTTEE_ACTIVITY.ACTION_CODES = CTTEE_POSITIONS.POSITION_CODE)
			</CFQUERY>
		
		
			<CFIF #Export.enrollee_type# EQ "FL" or #Export.enrollee_type# EQ "FLX">
				<cfset year_mem_status = "#Export.fcia_yr#">
			<CFELSE>
                <CFIF #Export.enrollee_type# EQ "S2" or #Export.enrollee_type# EQ "S2X" or #Export.enrollee_type# EQ "S2T" or #Export.enrollee_type# EQ "S2TX">
					<cfset year_mem_status = "#Export.st_yr#">
                <CFELSE>
	                <CFIF #Export.enrollee_type# EQ "AF" or #Export.enrollee_type# EQ "AFX">
						<cfset year_mem_status = "#cvitool.af_yr#">
	                <CFELSE>
	                	<CFIF #Export.enrollee_type# EQ "CR" or #Export.enrollee_type# EQ "CRX">
							<cfset year_mem_status = "#cvitool.cr_yr#">
	                	</CFIF>                 
	                </CFIF>           
            	</CFIF>
        	</CFIF>
			
			<!---loop through committies that have been applied to--->
			<cfset comm_applied_to = "">
			<cfloop query="Comm_Applicant">
				<cfset comm_applied_to = ListAppend(comm_applied_to, Comm_Applicant.description)>
			</cfloop>
			
			<!---looop through committies that member is sitting--->
			<cfset comm_sitting_to = "">
			<cfloop query="Comm_Sitting">
				<cfset comm_sitting_to = ListAppend(comm_sitting_to, Comm_Sitting.NAME_E)>
			</cfloop>
		
        
<!---			<CFX_SFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>--->
        
			<CFX_SFILE action="append" file="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv" output='"#enrollee_firstname#","#enrollee_lastname#","#company#","#title#","#fax#","#state_province#","#official_email#","#work_phone#","#prim_prac_area#","#year_mem_status#","#enrollee_type#","#prim_sub_area#","#employer_type_new#","#major_job_function#","#Profile_updated#","#cmtee_pref#","#issues#","#practice_area_spec#","#years_exp#","#practice_area_past#","#other_act_vol#","#other_nonact_vol#","#spec_int#","#spec_skills#","#comm_applied_to#","#comm_sitting_to#"'>
		</cfoutput>
	</cfif>
<cfelse>
	<cfif FileExists("#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv")>
	<!---<CFFILE username="#Variables.USERNAME#" password="#Variables.PASSWORD#" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>--->
    	  <CFFILE ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\export\#OTHER_CODE#_cttee.csv">
	</cfif>
</cfif>

<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>CVI Tools - Member(s) Details</title>

<!-- Script expand -->
<script>
function toggle(id){ 
  var element = document.getElementById(id); 
  element.style.display = (element.style.display == 'block') ? "none" : "block"; 
  } 
</script> 

<!-- Script pop-up window -->
<script type="text/javascript">
    var GB_ROOT_DIR = "http://tools.cia-ica.ca/common/greybox/";
</script>
<script type="text/javascript" src="http://tools.cia-ica.ca/common/greybox/AJS.js"></script>
<script type="text/javascript" src="http://tools.cia-ica.ca/common/greybox/AJS_fx.js"></script>
<script type="text/javascript" src="http://tools.cia-ica.ca/common/greybox/gb_scripts.js"></script>
<link href="http://tools.cia-ica.ca/common/greybox/gb_styles.css" rel="stylesheet" type="text/css" />
<link href="http://tools.cia-ica.ca/common/applicant.css" rel="stylesheet" type="text/css">
</head>

<BODY>

<div id="main">   

    <a name="top"></a>
    <div align="center"><br>
  <img src="../images/print-logo.gif" alt="CIA Logo ICA" width="208" height="71"><br></div>
  <div class="title">
    <img src="../images/comment.png" alt="Info" width="24" height="24" align="absmiddle">&nbsp;There are <cfoutput>#APPLICANTS.RECORDCOUNT# applicants for the #CTTEE.NAME_E#</cfoutput>
    </div>
 
<CFLOOP QUERY="APPLICANTS">
<CFOUTPUT>
<hr size="2" color="##ccc">
    <div class="content01">
        <div class="box01">First Name</div>
        <div class="box02">#Applicants.enrollee_firstname#</div>
        <div class="box05">Company</div>
        <div class="box06"><CFIF #Applicants.company# NEQ "">#Applicants.company#<cfelse>Not Available</CFIF></div>
        <br>
        <div class="box03">Last Name</div>
        <div class="box04">#Applicants.enrollee_lastname#</div>	
    </div> 
    <!-- Additional Contact Details -->
    <div class="add">
    <a href="javascript: toggle(22#id#123);"><img src="../images/bulletin-arrow.gif" alt="More information" align="absmiddle" border="0">&nbsp;Additional Contact Details</a><br>
        <div  id="22#id#123" style="display: none">
          <div class="addcontent01">
            <div class="box01">Job Title</div>
            <div class="box02">#Applicants.title#</div>
            <div class="box05">Fax</div>
            <div class="box06">#Applicants.fax#</div>
            <br>
            <div class="box03">Province of Residence</div>
            <div class="box04">#Applicants.state_province#</div>
            <div class="box05">Email Address</div>
            <div class="box06">#Applicants.official_email#</div>
            <br>
            <div class="box03">Phone</div>
            <div class="box04">#Applicants.work_phone#</div>
            <br><br>
       	  </div>
        </div>
    </div>
	<!-- End of Additional Contact Details -->
   
    
	<div class="content02">
        <div class="box01">Primary Practice Area*</div>
        <div class="box02"><cfif #Applicants.prim_prac_area# NEQ "">#Applicants.prim_prac_area#<cfelse>N/A</cfif></div>
        <div class="box05">Year of Achieving Membership Status</div>
        <div class="box06">    		
		<CFIF #Applicants.enrollee_type# EQ "FL" or #Applicants.enrollee_type# EQ "FLX">&nbsp;#Applicants.fcia_yr# <cfset year_achieving = "#Applicants.fcia_yr#">
<CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "S2" or #Applicants.enrollee_type# EQ "S2X" or #Applicants.enrollee_type# EQ "S2T" or #Applicants.enrollee_type# EQ "S2TX">&nbsp;#Applicants.st_yr# <cfset year_achieving = "#Applicants.st_yr#">
                <CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "AF" or #Applicants.enrollee_type# EQ "AFX">&nbsp;#cvitool.af_yr# <cfset year_achieving = "#cvitool.af_yr#">
                <CFELSE>
                <CFIF #Applicants.enrollee_type# EQ "CR" or #Applicants.enrollee_type# EQ "CRX">&nbsp;#cvitool.cr_yr# <cfset year_achieving = "#cvitool.cr_yr#">
                </CFIF>                 
                </CFIF>           
            	</CFIF>
        </CFIF>
        </div>
        <br>
        <div class="box03">Membership Status</div>
        <div class="box04">#Applicants.enrollee_type#</div>
	</div>
    <div class="add">
    <!-- Practice Area Details -->
	<a href="javascript: toggle(11#id#321);"><img src="../images/bulletin-arrow.gif" alt="More information" width="9" height="11" align="absmiddle" border="0">&nbsp;Practice Area Details</a><br>
        <div  id="11#id#321" style="display:none">
            <div class="addcontent02">
            <div class="box01">Primary Sub Category*</div>
            <div class="box02">#Applicants.prim_sub_area#</div>
            <div class="box05">Major Job Function*</div>
            <div class="box06">#Applicants.major_job_function#</div>            
            <div class="box03">Employer Type*</div>
            <div class="box04">#Applicants.employer_type_new#</div>
          </div>
        </div>
    </div>
    <!-- End of Practice Area Details -->

	<!-- BUTTONS -->
	<div class="content03">
        <div class="buttons">
            <a href="/members/volunteer_profile.cfm?ID=#id#&OTHER_CODE=#OTHER_CODE#" onClick="return GB_showFullScreen('Volunteer Profile', this.href)" class="regular"><img src="../images/add.png" alt="Profile" width="48" height="48">Additional Profile</a>
            <a href="/members/employment_codes.cfm" onClick="return GB_showFullScreen('List of codes', this.href)" class="regular"><img src="../images/comment.png" alt="Info" width="48" height="48">*Practice Area codes</a>
            <a href="Toolkit/Remove_confirm.cfm?Lang=E&ID=#Applicants.ID#&OTHER_CODE=#OTHER_CODE#&NAME=	  #Applicants.prefix# #Applicants.enrollee_firstname# #Applicants.enrollee_middlename# #Applicants.enrollee_lastname#&Task=Confirm" onClick="return GB_showCenter('Remove this person as an applicant for this committee ', this.href)" class="regular"><img src="../images/delete.png" alt="Delete" width="48" height="48">Remove this person</a>
            <!-- Export tool -->
            <a href="03_applicant_list_e.cfm?OTHER_CODE=#OTHER_CODE#&Task=ExportInfo" class="regular"><img src="../images/upload.png" alt="Export the Comittee information" width="48" height="48">Export to file</a>
            <a href="/members/cvi_search.cfm" class="regular" target="_blanc"><img src="../images/Search.png" alt="Search Tool" width="32" height="32">Search the Registry</a>         
            <a href="##top" class="regular"><img src="../images/home.png" alt="Back to the top" width="48" height="48">Back to the top</a>
            </div>
    </div>
            <!-- Export tool -->
			<cfif Task eq "ExportInfo">
            <div class="content04">
            Right-click on the link below and select <strong>"Save Target As..."</strong> to save this file to your local computer: <a href="/members/toolkit/export/#OTHER_CODE#_cttee.csv" target="_blank"><strong>#OTHER_CODE#_cttee.csv</strong></a></div>
            </cfif> 
                
    <!-- END of BUTTONS -->  
</cfoutput>
</CFLOOP>
</div>
 </BODY>
</HTML>

Open in new window

SOLUTION
Avatar of Randy Johnson
Randy Johnson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of koila

ASKER

I think this is the solution.... my other code wasn't worked so this guy converted . I've copied my old code on my other pages. here what he did.

      
<cfif #FileExists("#application.directory_path#\members\toolkit\import\#parsed_file_name#")#>
				<!--- <CFFILE USERNAME="#application.username#" PASSWORD="#application.password#" ACTION="DELETE" SOURCE="#application.directory_path#cce\articles\docs\#parsed_file_name#"> --->
				<!--- old one <CFFILE ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\import\#parsed_file_name#">
				<CFX_SFILE USERNAME="xxxx" PASSWORD="xxxxx" ACTION="DELETE" FILE="#application.directory_path#\members\toolkit\import\#parsed_file_name#">--->
				<cffile action="delete" file="#application.directory_path#\members\toolkit\import\#parsed_file_name#" >

Open in new window

Avatar of koila

ASKER

so in my case in my code please advise how i'm able to converted??
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ugh... too slow today ;-) I sound like an echo.  I'm gonna drop of guys.
Avatar of koila

ASKER

YOU ARE THE BEST !!!!! please help me on my others questions !!!
To convert your code you just need to replace all cfxs_ftp tags with cffile tags.  

You want to completely remove the username=""  on cffile tags.  username and password are not supported fields

cfdocs