ok i want to create a chart if an employee has filled something out.. LIKE
Employee Pat Joe Lisa Sue Service TriForm X X CAD X X X DT X X But using the code below it only seems to display the first looped record.. and it seems wrong. LIKE Employee Pat Joe Lisa Sue Service TriForm X CAD X DT X Any help on this would be great! Thanks Code Below. -paul <cfquery name="myRelations" DATASOURCE="ISresource"> SELECT DISTINCT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID, tblService.Service_ID, tblService.Service FROM tblRelations, tblService WHERE tblRelations.Service_ID = tblService.Service_ID ORDER BY Service; </cfquery> <cfscript> rsEmployee_NumRows = 0; rsEmployee_Index = 1; HLooper1_NumRows = 20; rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows; </cfscript> <cfquery name="rsEmployee" DATASOURCE="ISresource"> SELECT EmployeeID, LastName, FirstName FROM tblEmployee ORDER BY LastName; </cfquery> <table border="1"> <tr> <td bgcolor="#C0C0C0">Resource</td> <cfset endrw=rsEmployee_Index-1> <cfset HLooper1_numberColumns=20> <cfset numrows=1> <cfloop condition="numrows is not 0 and endrw less than rsEmployee.RecordCount"> <cfset startrw=endrw + 1> <cfset endrw=endrw + HLooper1_numberColumns> <cfloop query="rsEmployee" startrow="#startrw#" endrow="#endrw#"> <cfoutput> <td>#LEFT(rsEmployee.FirstName, 1)##rsEmployee.LastName#</td> </cfoutput> </cfloop> <cfset numrows = numrows - 1> </cfloop> </tr> <cfoutput query="myRelations" group="Service"> <tr> <td>#Trim(myRelations.Service)#</td> <cfset endrw=rsEmployee_Index-1> <cfset HLooper1_numberColumns=20> <cfset numrows=1> <cfloop condition="numrows is not 0 and endrw less than rsEmployee.RecordCount"> <cfset startrw=endrw + 1> <cfset endrw=endrw + HLooper1_numberColumns> <cfloop query="rsEmployee" startrow="#startrw#" endrow="#endrw#"> <cfif #myRelations.EmployeeID# EQ #rsEmployee.EmployeeID#> <td>+</td> <cfelse> <td>-</td> </cfif> </cfloop> <cfset numrows = numrows - 1> </cfloop> </tr> </CFOUTPUT> </table></table> ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
