ok this is going to sound long i have a phone list [we all do!] i can group by studio & display in one column employee phone info & such
or if i write it a different way i can show all office info LOOPed into 3 columns. But i cant seem to do both! I would like to use a group by studio like i have, but display employee info top, down the right top, down & again in 3 culms i have tried a few different ways & just keep getting deeper... Any help would be wonderful! Thanks -paul <cfquery name="Employees" datasource="RPH"> SELECT tblEmployee.Lastname + ' ' + tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.StatusID, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblPhone.PhoneTypeID, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EmployeeID AND tblPhone.PhoneTypeID = '1' AND tblEmployee.StudioID in (#FORM.StudioID#) AND tblEmployee.FloorID = tblFloor.floorid ORDER BY tblStudio.StudioName, Fullname, tblEmployee.EMPLOYEE_ID; </cfquery> <html> <head> <title>NBBJ Intranet / The Firm / People / Phone List</title> <script language='javascript' src='/include/js.js' type='text/javascript'></script> <cfoutput><script language='javascript' src='/include/layers_#curSect#.js' type='text/javascript'></script></cfoutput> </head> <body bgcolor='#ffffff' topmargin='0' leftmargin='0' marginheight='0' marginwidth='0' onmouseover='hideAll();' onmouseout='hideAll();'> <table border="0" cellpadding="2" cellspacing="0"> <CFOUTPUT QUERY="Employees" GROUP="StudioName"> <tr valign="top" align="center" bgcolor="##908e8e"> <td> <span class='subwhite'>Office - Studio</span><br> <img src='/images/shim.gif' width='' height='1' border='0' alt=''> </td> <td><span class='subwhite'>#Employees.City# - <a href="../../../thefirm/people/pictureboard.cfm?StudioID=#StudioID#" style="color: White;"> #Trim(Employees.StudioName)# </A></span><br> </td> </tr> <!--- Begin :: This is the section i would like to loop into 3 columns ---> <tr valign="middle"> <cfoutput group="fullname"> <td><B>#Employees.Fullname#</td> <td><cfoutput>#Trim(Employees.PhoneNumb)#<br></cfoutput></td> </tr> <!--- End :: This is the section i would like to loop into 3 columns ---> </cfoutput> </cfoutput> </table> </body> </html> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
