237 : <CFSET #YEAR# = #DateFormat(Now(),"YYYY")#>
238 : <CFQUERY DATASOURCE="ARCIVEWEBSITELOG2000" NAME="YEAR">
239 : SELECT ID,ACCT_ID,VISITORS_total,#MONTHfile#,VISITOR_counter_YEAR_1,VISITOR_counter_YEAR_2,VISITOR_counter_YEAR_3,VISITOR_counter_YEAR_4,VISITOR_counter_YEAR_5,VISITOR_counter_YEAR_6,VISITOR_counter_YEAR_7,VISITOR_counter_YEAR_8,VISITOR_counter_YEAR_9,VISITOR_counter_YEAR_10,VISITOR_counter_YEAR_11,VISITOR_counter_YEAR_12,VISITOR_counter_YEAR_13,VISITOR_counter_YEAR_14,VISITOR_counter_YEAR_15,VISITOR_counter_YEAR_16,VISITOR_counter_YEAR_17,VISITOR_counter_YEAR_18,VISITOR_counter_YEAR_19,VISITOR_counter_YEAR_20 FROM YEAR WHERE ID = #LOGid#
240 : </CFQUERY>
241 : <CFSET #FORM.ID# = #YEAR.ID#>
|