ok came into the office to try it out...
mucked about a bit...
and wasn't able to float it...
Isaac you can see a your modified example here...
http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm
im going home now..
bringing my laptop to hopefully get this working this weekend..
thanks again
-paul
<cfquery name="rsEmployee" datasource="ISresource" dbtype="ODBC">
SELECT EmployeeID, LastName, FirstName
FROM tblEmployee
ORDER BY LastName;
</cfquery>
<cfquery name="myRelations" datasource="ISresource" dbtype="ODBC">
SELECT Relation_ID, tblRelations.Service_ID, tblRelations.EmployeeID,
tblService.Service_ID, tblService.Service, tblEmployee.EmployeeID,
LastName, FirstName
FROM tblRelations, tblService, tblEmployee
WHERE tblRelations.Service_ID = tblService.Service_ID
AND tblRelations.EmployeeID IN (tblEmployee.EmployeeID)
ORDER BY Service, LastName;</cfquery>
<cfquery name="rsServices" datasource="ISresource" dbtype="ODBC">
SELECT tblRelations.Relation_ID, tblRelations.Service_ID,
tblRelations.EmployeeID, tblService.Service_ID, tblService.Service,
tblEmployee.EmployeeID, tblEmployee.LastName, tblEmployee.FirstName
FROM (tblRelations LEFT JOIN tblService ON tblService.Service_ID =
tblRelations.Service_ID)
INNER JOIN tblEmployee ON tblEmployee.EmployeeID IN
(tblRelations.EmployeeID)
<!--- AND tblRelations.EmployeeID = tblEmployee.EmployeeID --->
<!--- ORDER BY Service, LastName; ---></cfquery>
<cfscript>
rsEmployee_NumRows = 0;
rsEmployee_Index = 1;
HLooper1_NumRows = 20;
rsEmployee_NumRows = rsEmployee_NumRows + HLooper1_NumRows;
</cfscript>
<table border="1">
<tr>
<td bgcolor="#C0C0C0">Service</td>
<cfloop query="rsEmployee">
<cfoutput>
<td align="center">
#LEFT(rsEmployee.FirstName, 1)#.#LEFT(rsEmployee.LastName,
1)#.
#rsEmployee.EmployeeID#
</td>
</cfoutput>
</cfloop>
</tr>
<!--- Start Wierd CFIF Statemnt --->
<tr>
<cfoutput query="myRelations" group="Service">
<td>#Trim(myRelations.Service)#<br>
<!--- shows who we have in there --->
<cfoutput group="LastName">
<strong>#myRelations.EmployeeID#</strong><br>
</cfoutput></td>
<!--- If i coment this output out then it displays the look i want
but on shows the first selection in bold!!! <cfoutput
group="LastName">--->
<cfoutput>
<cfloop index="EmplID" list="#myRelations.EmployeeID#" delimiters=",">
<cfloop query="rsEmployee">
<cfif EmployeeID NEQ #EmplID#>
<tD><em>#rsEmployee.EmployeeID#</em></tD>
<CFELSE>
<td><strong>#rsEmployee.EmployeeID#</strong></td>
</CFIF>
</cfloop>
</cfloop>
<tr>
<td></td></cfoutput>
</tr>
</CFOUTPUT>
</table>
<br>
<strong>Isaac Dealey [code]</strong>
<table>
<cfoutput query="rsServices" group="Service_ID">
<tr><td>#Service#</td>
<cfoutput>
<td>#EmployeeID#</td>
</cfoutput>
</cfoutput></table>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
