the array courses are setup in saparate file . and then i call it through the include <cfinclude template="../includes/coursearray2.cfm">
here the array <!--- Setup Course Descriptions ---> <cfset arryCourses = ArrayNew(2)> <!--- display name [i][1] ---> <cfset arryCourses[1][1] = "Federal Conditions of Participation for Hospice Services"> <cfset arryCourses[2][1] = "General Hospice Orientation"> <cfset arryCourses[3][1] = "Benchmarking Hospice Operations"> <cfset arryCourses[4][1] = "Compliance Training & Clinical Decision Making"> <cfset arryCourses[5][1] = "Certifications & Recertifications"> <cfset arryCourses[6][1] = "Consideration of Radiation Therapy & Chemotherapy for Palliation of Pain & Symptoms"> <cfset arryCourses[7][1] = "Related Unrelated Issues"> <cfset arryCourses[8][1] = "Revocations Discharges & Aggressive Treatment"> <cfset arryCourses[9][1] = "General Hospice Documentation Guidelines"> <cfset arryCourses[10][1] = "Local Coverage Deterations & Hospice Eligibility"> <cfset arryCourses[11][1] = "Hospice Plan of Care"> <!--- test name [i][2] ---> <cfset arryCourses[1][2] = "Federal Conditions of Participation for Hospice Services"> <cfset arryCourses[2][2] = "General Hospice Orientation"> <cfset arryCourses[3][2] = "Benchmarking Hospice Operations"> <cfset arryCourses[4][2] = "Compliance Training & Clinical Decision Making"> <cfset arryCourses[5][2] = "Certifications & Recertifications"> <cfset arryCourses[6][2] = "Consideration of Radiation Therapy & Chemotherapy for Palliation of Pain & Symptoms"> <cfset arryCourses[7][2] = "Related Unrelated Issues"> <cfset arryCourses[8][2] = "Revocations Discharges & Aggressive Treatment"> <cfset arryCourses[9][2] = "General Hospice Documentation Guidelines"> <cfset arryCourses[10][2] = "Local Coverage Deterations & Hospice Eligibility"> <cfset arryCourses[11][2] = "Hospice Plan of Care"> <!--- Course Catalog Name ---> <cfset arryCourses[1][3] = "TRF 101.4"> <cfset arryCourses[2][3] = "TRF 101.6"> <cfset arryCourses[3][3] = "OPS 101.2"> <cfset arryCourses[4][3] = "CPL 101.3"> <cfset arryCourses[5][3] = "SVD 101.14"> <cfset arryCourses[6][3] = "SVD 101.15"> <cfset arryCourses[7][3] = "SVD 101.27"> <cfset arryCourses[8][3] = "SVD 101.28"> <cfset arryCourses[9][3] = "CPL 101.1"> <cfset arryCourses[10][3] = "CPL 101.2"> <cfset arryCourses[11][3] = "SHD 101.5"> >Where does arryCourses come from? Have you set it as a 2 dimensional array? >What error do you get if any? > >The problem is i want to see the employeeId and assosiate with this EMployee >courses > >this >>course. The reason i am doing this b/c this query gives the all required >>info . and then i will have the other query which gives the number of >>completed courses , so I will compare how many reuired and how many are >done ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4