August 29, 2008 10:05pm pdt

1. SidFishes 168,785
2. Zvonko 111,330
3. gdemaria 97,410
4. _agx_ 74,657
5. Plucka 63,800
6. SBennett 54,100
7. zadoc 37,230
8. hielo 35,850
9. dgrafx 32,800
10. erikTsomik 28,800
11. Mr_Nil 24,500
12. srikanthm... 20,810
13. pmascari 18,750
14. meverest 17,950
15. Kerrdo 15,300
16. Jester_48 14,200
17. msfletch 13,820
18. rob_loren... 13,360
19. angelIII 12,000
19. pigmentarts 12,000
21. BSSupport 11,000
22. digicidal 9,150
23. HuyBD 8,800
24. jason1178 8,350
25. rucky544 8,300

1. mrichmon 1,346,158
2. trailblazzy... 688,918
3. pinaldave 661,396
4. anandkp 591,655
5. dgrafx 544,738
6. SidFishes 544,735
7. gdemaria 539,331
8. _agx_ 423,122
9. Plucka 405,168
10. Tacobell777 390,907
11. Jester_48 385,445
12. danrosent... 348,915
13. mkishline 295,040
14. mmc98dl1 271,238
15. entrance... 248,605
16. SBennett 239,190
17. jyokum 238,673
18. usachrisk... 237,378
19. rob_loren... 223,358
20. cheekycj 205,597
21. jimmy282 198,834
22. hart 192,788
23. substand 189,138
24. CFDevHead 178,970
25. Mause 172,288

04.08.2008 at 06:44AM PDT, ID: 23304510

	[x] Attachment Details

ColdFusion cfloop problem

Asked by erikTsomik in ColdFusion Application Server, ColdFusion Studio, Cold Fusion Markup Language

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

SO the way I loop is follow:

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:

           
           
             <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 coursename eq "#arryCourses[i][3]#"  and completionDate gt "">
                      <td valign="top" class="tdctr"></td>  
                      <cfelseif coursename neq "#arryCourses[i][3]#" and completiondate eq "">
                      	<td valign="top" class="tdctr">X</td>  
                      <cfelse>
                        <td valign="top" class="tdctr">N/A</td>
 
</cfif>
 
						</cfloop>
                        
					</tr>
				</cfif>
				<cfset holdemp = "#last_Name#, #First_Name#">
				
			</cfif>
			<cfif lastLocation neq LocationID>
				<cfif lastLocation neq "***">
					<tr>
						<th valign="top" class="yellowBgCenter">#arryEmployees[1]#</th>
						<th valign="top" class="yellowBgCenter">#arryEmployees[2]#</th>
						<th valign="top" class="yellowBgCenter">Totals</th>
						<cfloop from="1" to="#ArrayLen(arryCourses)#" index="i">
							<td valign="top" class="yellowBgCenter">#arryCntTotals[i][1]#</td>
							<cfset arryCntTotals[i][1] = 0>
						</cfloop>
					</tr>
				</cfif>
			</cfif>
			<!--- process this record --->
			<cfset arryEmployees[1] = "#Name#">
			<cfset arryEmployees[2] = "#locationID#">
   
 
 
			<cfset lastEmp = EmployeeiD>
			<cfset lastLocation = LocationID>
		</cfloop>

           
         

Keywords: ColdFusion cfloop problem

	Title
1	cfloop. cfbreak
2	cfinsert or cfloop to insert multiple reco…
3	CFLOOP
4	CFLOOP
5	CFLOOP where no record exists
6	CFLOOP

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

ColdFusion cfloop problem

Asked by erikTsomik in ColdFusion Application Server, ColdFusion Studio, Cold Fusion Markup Language

About this solution