Mathew & all thank you! got me back on track! thank you! what i did below. -paul
<cfquery name="Employees" datasource="RPH"> SELECT tblEmployee.Lastname + ' ' + tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudio.StudioName, tblOffice.OfficeID, tblOffice.City, tblPhone.PhoneNumb, tblFloor.floor FROM tblEmployee, tblStudio, tblOffice, tblPhone, tblFloor WHERE tblEmployee.studioid = tblStudio.studioid AND tblOffice.OfficeID = '#FORM.OfficeID#' AND tblPhone.EmpResID = tblEmployee.EMPLOYEE_ID AND tblEmployee.studioid in (#FORM.StudioID#) AND tblEmployee.floorid = tblFloor.floorid ORDER BY tblStudio.StudioName, Fullname, tblEmployee.EMPLOYEE_ID; </cfquery> <cfinclude template="../top.cfm"> <table border="1" align="left" cellspacing="0" cellpadding="0"> <tr> <td align="center" valign="top"><b>Employee Admin Page</b></td> </tr> <tr> <td align="center" valign="top"><a href="Emp_Form.cfm">Add an Employee</a> :: <a href="../Picture_Board/Default.cfm">Search the Picture Board!</a></td> </tr> <tr> <td> <table border="1" cellpadding="0" cellspacing="0"> <tr valign="top" align="center"> <td><b>Name</b></td> <td><b>Extension</b></td> <td colspan="3"><b>Edit</b></td> </tr> <CFOUTPUT QUERY="Employees" GROUP="StudioName"> <tr> <td colspan="5" align="center" valign="top"><a href="Emp_Form.cfm">Add an Employee</a> :: <a href="../Picture_Board/Default.cfm">Search the Picture Board!</a></td> </tr> <tr valign="top" align="center" bgcolor="##336666"> <td colspan="2"><b><font color="##FFFFFF">Office - Studio</font></b></td> <td colspan="3"><b><font color="##FFFFFF">#Employees.City# - <a href="../Picture_Board/Emp_Studio_Browse.cfm?StudioID=#StudioID#" style="color: White;">#Employees.StudioName#</A></font></b></td> </tr> <tr valign="middle"> <cfoutput group="fullname"> <td><B>#Employees.Fullname#</td> <td><cfoutput>#Employees.PhoneNumb#<br></cfoutput> </td> <td align="justify"> <A HREF="Emp_Form.cfm?EmployeeID=#Employees.EmployeeID#">Edit</A></td> <td align="justify"> <A HREF="Emp_Photo2.cfm?EmployeeId=#Employees.EmployeeId#">Photo</A></td> <form action="Emp_Delete.cfm" method="post" name="D_Emp"> <td align="justify"> <INPUT TYPE="checkbox" NAME="Status" VALUE="Yes" <cfif (# LSNumberFormat(Employees.Status) # EQ 1)>CHECKED</cfif>><input type="hidden" name="EmployeeID" value="#Employees.EmployeeID#"><cfif #Employees.Status# EQ 0><input type="submit" value="check to hide user"><cfelse><input type="submit" value="un-check to show user"></cfif></td></form> </tr> </cfoutput> </cfoutput> </table> </td> </tr> <tr> <td align="center" valign="top"><A HREF="Emp_Form.cfm">Add an Employee</A> :: <a href="../Picture_Board/Default.cfm">Search the Picture Board!</a></td> </tr> </table> ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
