In my query I need to loop through the courses and find out wheather or not
perosn require to take courses. if the do not require to take any courses then
mark the cell N/a. If they do require then check for completion. If they had
already taking the course and completed then leave the cell blank. If they
required but never completed then marked X. I did the cfloop over this issue
but does not seems to be working . I do not know what to do next
This is the list of all courses
<cfset listCourse="31,32,33,136,35,36,37,135,38,39,40">
The query get all required courses.
<cfset lastLocation = "***">
<cfset lastEmp = "***">
<!--- ==============Loop thru query results
============================ --->
<cfloop query="getReport">
<cfif lastEmp neq EmployeeiD>
<cfif lastEmp neq "***">
<tr>
<td valign="top"
>#arryEmployees[1]#</td>
<td valign="top"
class="tdctr">#arryEmployees[2]#</td>
<td valign="top">#holdemp#</td>
<cfloop from="1"
to="#ArrayLen(arryCourses)#" index="i">
<cfif comparray[i] gt 0>
<cfif ListFind(listCourse,courseID)>
<td valign="top" class="tdctr">N/A</td>
</cfif>
<td valign="top" class="tdctr"></td>
<cfelse>
<td valign="top" class="tdctr">X</td>
</cfif>
</cfloop>
</tr>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:302870
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
