> directory="#dirName#"
directory="#variables.dirName#", to distinguish it from
form.dirName
>
destination="C:\Inetpub\wwwroot\webapps\ipa_warehouse\fileformat"
destination="C:\Inetpub\wwwroot\webapps\ipa_warehouse\fileformat\",
with a backslash at the end
> WHERE ACTIVITY_DATE > '1/1/2005'
WHERE ACTIVITY_DATE > #createdate(2005,1,1)#, perhaps,
without the single quotes
> #dirName##dirFile#.cln
what does it point to, given that #dirName##dirFile# points
to a file?
> <cffile action="write" file="#dirName##dirFile#.cln"
output="foutput">
<cfoutput query="foutput">
<cffile action="append" file="#dirName##dirFile#.cln"
output="#SEQ_MEMB_ID#,#ACTIVITY_DATE#,#PCP#,#Spec#,#WDW_STATE#,#WDW_FUNDING_COUNTY#,#WDW_PRODUCT#,#PLAN_CODE#,#WDW_IPA_ID#,#WDW_PCP_ID#,#WDW_INPUT_CHANNEL#,#WDW_COHORT#,#WDW_ELIG_CATEGORY#,#MASTER_DOB#,#MASTER_SEX#,#pop#,#doc#,#dob#,#age#,#sex#,#Year#">
</cfoutput>