thanks Chuck & all
but it is still not working the way i envision it.
any more advice on this would be great!
i know i know it, just cant get it!
i have tried nesting different
the Current Results:
Adkins , John 1111(241) Edit Photo
Adkins , John 222-223-1111 Edit Photo
Anderson , Dorman 1111 Edit Photo
Anderson , Dorman 222-223-1111 Edit Photo
Appleford , Chris 222-223-1111 Edit Photo
Ayars , Daniel 222-621-1111
What i want the Results to be:
Adkins , John 1111(241) Edit Photo
222-223-1111
Anderson , Dorman 1111 Edit Photo
222-223-1111
Appleford , Chris 222-223-1111 Edit Photo
Ayars , Daniel 222-621-1111
Thank You All
-paul
<cfquery name="Employees" datasource="RPH">
SELECT tblEmployee.FirstName, tblEmployee.EMPLOYEE_ID, tblEmployee.LastName,
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 #FORM.OrderBy#, tblOffice.City, tblEmployee.EMPLOYEE_ID;
</cfquery>
Name
Extension
Edit
<CFOUTPUT QUERY="Employees" GROUP="StudioName">
Office - Studio
#Employees.City# - #Employees.StudioName#
<cfoutput>
#Employees.LastName#, #Employees.FirstName# #Employees.PhoneNumb#
Edit
Photo
<form action="Emp_Delete.cfm" method="post" name="D_Emp">
<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></form>
</cfoutput>
</cfoutput>
______________________________________________________________________
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
