koila
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.TagAtt ributeNotF oundExcept ion: Attribute validation error for tag file.
at coldfusion.compiler.TagNod e.getAttri buteInfo(T agNode.jav a:244)
at coldfusion.compiler.StmtAs sembler.em itSetter(S tmtAssembl er.java:10 38)
at coldfusion.compiler.StmtAs sembler.se tAttribute s(StmtAsse mbler.java :866)
at coldfusion.compiler.StmtAs sembler.cf tag(StmtAs sembler.ja va:594)
at coldfusion.compiler.StmtAs sembler.as sembleStat ement(Stmt Assembler. java:296)
at coldfusion.compiler.Templa teAssemble r.assemble Statement( TemplateAs sembler.ja va:213)
at coldfusion.compiler.StmtAs sembler.bl ock(StmtAs sembler.ja va:193)
at coldfusion.compiler.StmtAs sembler.cf if(StmtAss embler.jav a:1973)
at coldfusion.compiler.StmtAs sembler.as sembleStat ement(Stmt Assembler. java:234)
at coldfusion.compiler.Templa teAssemble r.assemble Statement( TemplateAs sembler.ja va:213)
at coldfusion.compiler.StmtAs sembler.bl ock(StmtAs sembler.ja va:193)
at coldfusion.compiler.StmtAs sembler.as sembleStat ement(Stmt Assembler. java:214)
at coldfusion.compiler.Templa teAssemble r.assemble Statement( TemplateAs sembler.ja va:213)
at coldfusion.compiler.StmtAs sembler.cf if(StmtAss embler.jav a:1980)
at coldfusion.compiler.StmtAs sembler.as sembleStat ement(Stmt Assembler. java:234)
at coldfusion.compiler.Templa teAssemble r.assemble Statement( TemplateAs sembler.ja va:213)
at coldfusion.compiler.StmtAs sembler.bl ock(StmtAs sembler.ja va:193)
at coldfusion.compiler.StmtAs sembler.cr eateFactor edMethod(S tmtAssembl er.java:41 3)
at coldfusion.compiler.StmtAs sembler.fa ctoredNode (StmtAssem bler.java: 371)
at coldfusion.compiler.StmtAs sembler.as sembleStat ement(Stmt Assembler. java:310)
at coldfusion.compiler.Templa teAssemble r.assemble Statement( TemplateAs sembler.ja va:213)
at coldfusion.compiler.StmtAs sembler.bl ock(StmtAs sembler.ja va:189)
at coldfusion.compiler.Templa teAssemble r.assemble Page(Templ ateAssembl er.java:17 5)
at coldfusion.compiler.Templa teAssemble r.assemble (TemplateA ssembler.j ava:58)
at coldfusion.compiler.NeoTra nslator.tr anslateJav a(NeoTrans lator.java :265)
at coldfusion.compiler.NeoTra nslator.tr anslateJav a(NeoTrans lator.java :97)
at coldfusion.runtime.Templat eClassLoad er$1.fetch (TemplateC lassLoader .java:263)
at coldfusion.util.LruCache.g et(LruCach e.java:188 )
at coldfusion.runtime.Templat eClassLoad er$Templat eCache.fet chSerial(T emplateCla ssLoader.j ava:214)
at coldfusion.util.AbstractCa che.fetch( AbstractCa che.java:5 8)
at coldfusion.util.SoftCache. get(SoftCa che.java:8 1)
at coldfusion.runtime.Templat eClassLoad er.findCla ss(Templat eClassLoad er.java:35 6)
at coldfusion.filter.PathFilt er.invoke( PathFilter .java:73)
at coldfusion.filter.Exceptio nFilter.in voke(Excep tionFilter .java:47)
at coldfusion.filter.ClientSc opePersist enceFilter .invoke(Cl ientScopeP ersistence Filter.jav a:28)
at coldfusion.filter.BrowserF ilter.invo ke(Browser Filter.jav a:35)
at coldfusion.filter.GlobalsF ilter.invo ke(Globals Filter.jav a:43)
at coldfusion.filter.Datasour ceFilter.i nvoke(Data sourceFilt er.java:22 )
at coldfusion.CfmServlet.serv ice(CfmSer vlet.java: 105)
at jrun.servlet.ServletInvoke r.invoke(S ervletInvo ker.java:9 1)
at jrun.servlet.JRunInvokerCh ain.invoke Next(JRunI nvokerChai n.java:42)
at jrun.servlet.JRunRequestDi spatcher.i nvoke(JRun RequestDis patcher.ja va:252)
at jrun.servlet.ServletEngine Service.di spatch(Ser vletEngine Service.ja va:527)
at jrun.servlet.jrpp.JRunProx yService.i nvokeRunna ble(JRunPr oxyService .java:192)
at jrunx.scheduler.ThreadPool $Downstrea mMetrics.i nvokeRunna ble(Thread Pool.java: 348)
at jrunx.scheduler.ThreadPool $ThreadThr ottle.invo keRunnable (ThreadPoo l.java:451 )
at jrunx.scheduler.ThreadPool $UpstreamM etrics.inv okeRunnabl e(ThreadPo ol.java:29 4)
at jrunx.scheduler.WorkerThre ad.run(Wor kerThread. java:66)
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.TagAtt
at coldfusion.compiler.TagNod
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.StmtAs
at coldfusion.compiler.Templa
at coldfusion.compiler.Templa
at coldfusion.compiler.NeoTra
at coldfusion.compiler.NeoTra
at coldfusion.runtime.Templat
at coldfusion.util.LruCache.g
at coldfusion.runtime.Templat
at coldfusion.util.AbstractCa
at coldfusion.util.SoftCache.
at coldfusion.runtime.Templat
at coldfusion.filter.PathFilt
at coldfusion.filter.Exceptio
at coldfusion.filter.ClientSc
at coldfusion.filter.BrowserF
at coldfusion.filter.GlobalsF
at coldfusion.filter.Datasour
at coldfusion.CfmServlet.serv
at jrun.servlet.ServletInvoke
at jrun.servlet.JRunInvokerCh
at jrun.servlet.JRunRequestDi
at jrun.servlet.ServletEngine
at jrun.servlet.jrpp.JRunProx
at jrunx.scheduler.ThreadPool
at jrunx.scheduler.ThreadPool
at jrunx.scheduler.ThreadPool
at jrunx.scheduler.WorkerThre
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.
ASKER
so this is my actual code.
<cfset Variables.USERNAME="xxxxxx ">
<cfset Variables.PASSWORD="xxxxxx x">
so the username and password was wrong I've change to the new one. and it didn't work?
<cfset Variables.USERNAME="xxxxxx
<cfset Variables.PASSWORD="xxxxxx
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?
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?
(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.userN ame#">
... because the <cffile> tag doesn't have a "username" attribute.
Post your code an we can help you fix it.
> 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.userN
... because the <cffile> tag doesn't have a "username" attribute.
Post your code an we can help you fix it.
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.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM enrollees, cttee_activity
WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUM BER = CTTEE_ACTIVITY.ID)
ORDER BY enrollees.enrollee_lastnam e, enrollees.enrollee_firstna me
</CFQUERY>
<CFQUERY NAME="cvitool" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM cvitool
</CFQUERY>
<CFQUERY NAME="Cttee" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT name_e, cttee_code
FROM cttee_codes_tors, cttee_activity
WHERE (cttee_activity.other_code = cttee_codes_tors.cttee_cod e) AND (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#')
</CFQUERY>
<CFQUERY NAME="Applicants2" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM enrollees, cttee_activity
WHERE (CTTEE_ACTIVITY.OTHER_CODE = 'ANY') AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUM BER = CTTEE_ACTIVITY.ID)
ORDER BY enrollees.enrollee_lastnam e, enrollees.enrollee_firstna me
</CFQUERY>
<cfset username ="xxxx-ftp">
<cfset password = "xxxxxxx">
<!--- this was my previous code on the old hosting
<cfset Variables.USERNAME="xxxxx" >
<cfset Variables.PASSWORD="xxxxxx x">--->
<cfset ApplicantLIST=ValueList(Ap plicants.r ef_id)>
<cfset ApplicantLIST2=ValueList(A pplicants2 .ref_id)>
<cfset CompleteList=ListAppend(Ap plicantLIS T, ApplicantLIST2)>
<CFQUERY NAME="Committee" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE (ENROLLEES.REF_ID in (#CompleteList#)) AND (ENROLLEES.ENROLLEE_ID_NUM BER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_COD E) AND (CTTEE_ACTIVITY.ACTION_COD ES = CTTEE_POSITIONS.POSITION_C ODE)
</CFQUERY>
<!-- Export Tool -->
<cfparam name="Task" default="">
<cfif Task eq "ExportInfo">
<CFQUERY NAME="Export" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM enrollees, cttee_activity, cvitool
WHERE (CTTEE_ACTIVITY.OTHER_CODE = '#OTHER_CODE#') AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'APPLICANT') AND (ENROLLEES.ENROLLEE_ID_NUM BER = CTTEE_ACTIVITY.ID) AND (ENROLLEES.ENROLLEE_ID_NUM BER = CVITOOL.ID)
ORDER BY enrollees.enrollee_lastnam e, enrollees.enrollee_firstna me
</CFQUERY>
<cfscript>
/**
* Fixes text using Microsoft Latin-1 "Extentions", 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), "€", "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), "™", "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), " ", "All");
text = Replace(text, Chr(163), "£", "All");
text = Replace(text, Chr(169), "©", "All");
text = Replace(text, Chr(176), "°", "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 < > &
text = ReReplace(text, "&##038;", "&", "All");
text = ReReplace(text, "&##060;", "<", "All");
text = ReReplace(text, "&##062;", ">", "All");
// supply missing semicolon at the end of & "
text = ReReplace(text, "&(^;)", "&\1", "All");
text = ReReplace(text, ""(^;)", ""\1", "All");
return text;
}
</cfscript>
<CFX_SFILE username="#Variables.USERN AME#" password="#Variables.PASSW ORD#" action="write" nameconflict="OVERWRITE" file="#application.directo ry_path#\m embers\too lkit\expor t\#OTHER_C ODE#_cttee .csv" output='First Name,Last Name,Company,Job Title,Fax,Province,Email,P hone,Prima ry 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.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM cttee_activity
WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'Applicant')
</CFQUERY>
<CFQUERY NAME="Comm_Sitting" datasource="#application.d atasource# " username="#application.use rname#" password="#application.pas sword#">
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (ENROLLEES.ENROLLEE_ID_NUM BER = CTTEE_ACTIVITY.ID) AND (CTTEE_ACTIVITY.ACTIVITY_T YPE = 'COMMITTEE') AND (CTTEE_ACTIVITY.THRU_DATE > getdate()) AND (CTTEE_ACTIVITY.OTHER_CODE = CTTEE_CODES_TORS.CTTEE_COD E) AND (CTTEE_ACTIVITY.ACTION_COD ES = CTTEE_POSITIONS.POSITION_C ODE)
</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.USERN AME#" password="#Variables.PASSW ORD#" action="append" file="#application.directo ry_path#\m embers\too lkit\expor t\#OTHER_C ODE#_cttee .csv" output='"#enrollee_firstna me#","#enr ollee_last name#","#c ompany#"," #title#"," #fax#","#s tate_provi nce#","#of ficial_ema il#","#wor k_phone#", "#prim_pra c_area#"," #year_mem_ status#"," #enrollee_ type#","#p rim_sub_ar ea#","#emp loyer_type _new#","#m ajor_job_f unction#", "#Profile_ updated#", "#cmtee_pr ef#","#iss ues#","#pr actice_are a_spec#"," #years_exp #","#pract ice_area_p ast#","#ot her_act_vo l#","#othe r_nonact_v ol#","#spe c_int#","# spec_skill s#","#comm _applied_t o#","#comm _sitting_t o#"'>
</cfoutput>
</cfif>
<cfelse>
<cfif FileExists("#application.d irectory_p ath#\membe rs\toolkit \export\#O THER_CODE# _cttee.csv ")>
<CFFILE username="#Variables.USERN AME#" password="#Variables.PASSW ORD#" ACTION="DELETE" FILE="#application.directo ry_path#\m embers\too lkit\expor t\#OTHER_C ODE#_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"></scr ipt>
<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.cs s" 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"> Th ere are <cfoutput>#APPLICANTS.RECO RDCOUNT# 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_f irstname#< /div>
<div class="box05">Company</div >
<div class="box06"><CFIF #Applicants.company# NEQ "">#Applicants.company#<cf else>Not Available</CFIF></div>
<br>
<div class="box03">Last Name</div>
<div class="box04">#Applicants. enrollee_l astname#</ div>
</div>
<!-- Additional Contact Details -->
<div class="add">
<a href="javascript: toggle(22#id#123);"><img src="../images/bulletin-ar row.gif" alt="More information" align="absmiddle" border="0"> Additiona l 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#</di v>
<div class="box05">Fax</div>
<div class="box06">#Applicants. fax#</div>
<br>
<div class="box03">Province of Residence</div>
<div class="box04">#Applicants. state_prov ince#</div >
<div class="box05">Email Address</div>
<div class="box06">#Applicants. official_e mail#</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_a rea#<cfels e>N/A</cfi f></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"> #Applicants.fc ia_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"> #Applicants.s t_yr# <cfset year_achieving = "#Applicants.st_yr#">
<CFELSE>
<CFIF #Applicants.enrollee_type# EQ "AF" or #Applicants.enrollee_type# EQ "AFX"> #cvitool.af_yr # <cfset year_achieving = "#cvitool.af_yr#">
<CFELSE>
<CFIF #Applicants.enrollee_type# EQ "CR" or #Applicants.enrollee_type# EQ "CRX"> #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_t ype#</div>
</div>
<div class="add">
<!-- Practice Area Details -->
<a href="javascript: toggle(11#id#321);"><img src="../images/bulletin-ar row.gif" alt="More information" width="9" height="11" align="absmiddle" border="0"> 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_a rea#</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_t ype_new#</ div>
</div>
</div>
</div>
<!-- End of Practice Area Details -->
<!-- BUTTONS -->
<div class="content03">
<div class="buttons">
<a href="/members/volunteer_p rofile.cfm ?ID=#id#&O THER_CODE= #OTHER_COD E#" onClick="return GB_showFullScreen('Volunte er 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_confi rm.cfm?Lan g=E&ID=#Ap plicants.I D#&OTHER_C ODE=#OTHER _CODE#&NAM E= #Applicants.prefix# #Applicants.enrollee_first name# #Applicants.enrollee_middl ename# #Applicants.enrollee_lastn ame#&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=#OTHE R_CODE#&Ta sk=ExportI nfo" 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/exp ort/#OTHER _CODE#_ctt ee.csv" target="_blank"><strong>#O THER_CODE# _cttee.csv </strong>< /a></div>
</cfif>
<!-- END of BUTTONS -->
</cfoutput>
</CFLOOP>
</div>
</BODY>
</HTML>
--------------------
<CFQUERY NAME="Applicants" datasource="#application.d
SELECT *
FROM enrollees, cttee_activity
WHERE (CTTEE_ACTIVITY.OTHER_CODE
ORDER BY enrollees.enrollee_lastnam
</CFQUERY>
<CFQUERY NAME="cvitool" datasource="#application.d
SELECT *
FROM cvitool
</CFQUERY>
<CFQUERY NAME="Cttee" datasource="#application.d
SELECT name_e, cttee_code
FROM cttee_codes_tors, cttee_activity
WHERE (cttee_activity.other_code
</CFQUERY>
<CFQUERY NAME="Applicants2" datasource="#application.d
SELECT *
FROM enrollees, cttee_activity
WHERE (CTTEE_ACTIVITY.OTHER_CODE
ORDER BY enrollees.enrollee_lastnam
</CFQUERY>
<cfset username ="xxxx-ftp">
<cfset password = "xxxxxxx">
<!--- this was my previous code on the old hosting
<cfset Variables.USERNAME="xxxxx"
<cfset Variables.PASSWORD="xxxxxx
<cfset ApplicantLIST=ValueList(Ap
<cfset ApplicantLIST2=ValueList(A
<cfset CompleteList=ListAppend(Ap
<CFQUERY NAME="Committee" datasource="#application.d
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE (ENROLLEES.REF_ID in (#CompleteList#)) AND (ENROLLEES.ENROLLEE_ID_NUM
</CFQUERY>
<!-- Export Tool -->
<cfparam name="Task" default="">
<cfif Task eq "ExportInfo">
<CFQUERY NAME="Export" datasource="#application.d
SELECT *
FROM enrollees, cttee_activity, cvitool
WHERE (CTTEE_ACTIVITY.OTHER_CODE
ORDER BY enrollees.enrollee_lastnam
</CFQUERY>
<cfscript>
/**
* Fixes text using Microsoft Latin-1 "Extentions", 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), "€", "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), "™", "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), " ", "All");
text = Replace(text, Chr(163), "£", "All");
text = Replace(text, Chr(169), "©", "All");
text = Replace(text, Chr(176), "°", "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})(
// fix obscure numeric rendering of < > &
text = ReReplace(text, "&##038;", "&", "All");
text = ReReplace(text, "&##060;", "<", "All");
text = ReReplace(text, "&##062;", ">", "All");
// supply missing semicolon at the end of & "
text = ReReplace(text, "&(^;)", "&\1", "All");
text = ReReplace(text, ""(^;)", ""\1", "All");
return text;
}
</cfscript>
<CFX_SFILE username="#Variables.USERN
<cfif Applicants.RecordCount gt 0>
<cfoutput query="Export">
<CFQUERY NAME="Comm_Applicant" datasource="#application.d
SELECT *
FROM cttee_activity
WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (CTTEE_ACTIVITY.ACTIVITY_T
</CFQUERY>
<CFQUERY NAME="Comm_Sitting" datasource="#application.d
SELECT *
FROM enrollees, cttee_activity, cttee_codes_tors, cttee_positions
WHERE (CTTEE_ACTIVITY.ID = #Export.ID#) AND (ENROLLEES.ENROLLEE_ID_NUM
</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
</cfloop>
<!---looop through committies that member is sitting--->
<cfset comm_sitting_to = "">
<cfloop query="Comm_Sitting">
<cfset comm_sitting_to = ListAppend(comm_sitting_to
</cfloop>
<CFX_SFILE username="#Variables.USERN
</cfoutput>
</cfif>
<cfelse>
<cfif FileExists("#application.d
<CFFILE username="#Variables.USERN
</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
<script type="text/javascript" src="../common/greybox/AJS
<script type="text/javascript" src="../common/greybox/gb_
<link href="../common/greybox/gb
<link href="../common/applicant.
</head>
<BODY>
<div id="main">
<a name="top"></a>
<div align="center"><br>
<img src="../images/print-logo.
<div class="title">
<img src="../images/comment.png
</div>
<CFLOOP QUERY="APPLICANTS">
<CFOUTPUT>
<hr size="2" color="##ccc">
<div class="content01">
<div class="box01">First Name</div>
<div class="box02">#Applicants.
<div class="box05">Company</div
<div class="box06"><CFIF #Applicants.company# NEQ "">#Applicants.company#<cf
<br>
<div class="box03">Last Name</div>
<div class="box04">#Applicants.
</div>
<!-- Additional Contact Details -->
<div class="add">
<a href="javascript: toggle(22#id#123);"><img src="../images/bulletin-ar
<div id="22#id#123" style="display: none">
<div class="addcontent01">
<div class="box01">Job Title</div>
<div class="box02">#Applicants.
<div class="box05">Fax</div>
<div class="box06">#Applicants.
<br>
<div class="box03">Province of Residence</div>
<div class="box04">#Applicants.
<div class="box05">Email Address</div>
<div class="box06">#Applicants.
<br>
<div class="box03">Phone</div>
<div class="box04">#Applicants.
<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
<div class="box05">Year of Achieving Membership Status</div>
<div class="box06">
<CFIF #Applicants.enrollee_type#
<CFELSE>
<CFIF #Applicants.enrollee_type#
<CFELSE>
<CFIF #Applicants.enrollee_type#
<CFELSE>
<CFIF #Applicants.enrollee_type#
</CFIF>
</CFIF>
</CFIF>
</CFIF>
</div>
<br>
<div class="box03">Membership Status</div>
<div class="box04">#Applicants.
</div>
<div class="add">
<!-- Practice Area Details -->
<a href="javascript: toggle(11#id#321);"><img src="../images/bulletin-ar
<div id="11#id#321" style="display:none">
<div class="addcontent02">
<div class="box01">Primary Sub Category*</div>
<div class="box02">#Applicants.
<div class="box05">Major Job Function*</div>
<div class="box06">#Applicants.
<div class="box03">Employer Type*</div>
<div class="box04">#Applicants.
</div>
</div>
</div>
<!-- End of Practice Area Details -->
<!-- BUTTONS -->
<div class="content03">
<div class="buttons">
<a href="/members/volunteer_p
<a href="/members/employment_
<a href="Toolkit/Remove_confi
<!-- Export tool -->
<a href="03_applicant_list_e.
<a href="/members/cvi_search.
<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/exp
</cfif>
<!-- END of BUTTONS -->
</cfoutput>
</CFLOOP>
</div>
</BODY>
</HTML>
> <CFFILE username="#Variables.USERN AME#"
password="#Variables.PASSW ORD#" 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" ....>
password="#Variables.PASSW
> ....
CFFile doesn't have a username attribute. As suggested, just remove username and password from that tag and it should work.
<CFFILE ACTION="DELETE" ....>
ASKER
hello AGX
the error is in this part for sure.
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>
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>
ASKER
I did the following changes. I've remove the username and password on all CFX_SFILE and CFFILE
As you know before on my others page,
<!---
<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'>
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>
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>
Did that eliminate the errors?
ASKER
here is an image of the errors
<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>
<!---
<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'>
<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>
ASKER
no it didn't I still getting the errors. I really appreciate your help. please advise. I will copy the full code now.
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 "Extentions", 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), "€", "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), "™", "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), " ", "All");
text = Replace(text, Chr(163), "£", "All");
text = Replace(text, Chr(169), "©", "All");
text = Replace(text, Chr(176), "°", "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 < > &
text = ReReplace(text, "&##038;", "&", "All");
text = ReReplace(text, "&##060;", "<", "All");
text = ReReplace(text, "&##062;", ">", "All");
// supply missing semicolon at the end of & "
text = ReReplace(text, "&(^;)", "&\1", "All");
text = ReReplace(text, ""(^;)", ""\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"> 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"> 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"> #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"> #Applicants.st_yr# <cfset year_achieving = "#Applicants.st_yr#">
<CFELSE>
<CFIF #Applicants.enrollee_type# EQ "AF" or #Applicants.enrollee_type# EQ "AFX"> #cvitool.af_yr# <cfset year_achieving = "#cvitool.af_yr#">
<CFELSE>
<CFIF #Applicants.enrollee_type# EQ "CR" or #Applicants.enrollee_type# EQ "CRX"> #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"> 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>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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#" >
ASKER
so in my case in my code please advise how i'm able to converted??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ugh... too slow today ;-) I sound like an echo. I'm gonna drop of guys.
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
You want to completely remove the username="" on cffile tags. username and password are not supported fields
cfdocs
ASKER
Please help me on this one:
https://www.experts-exchange.com/questions/28454201/HTML-Heamail-unsubscribe.html
https://www.experts-exchange.com/questions/28454201/HTML-Heamail-unsubscribe.html
ASKER
AGX, I need your help please.
https://www.experts-exchange.com/questions/28457607/how-do-you-pass-a-variable-in-ColdFusion-via-a-url.html
https://www.experts-exchange.com/questions/28457607/how-do-you-pass-a-variable-in-ColdFusion-via-a-url.html