Since cfoutput creates the table one row at a time as each query row is output, wouldn't it be possible to put a cfif statement in the cfoutput to set first and last name to blank if they already exist?
-----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:23 PM To: CF-Talk Subject: RE: Group in cfoutput query. brain fart 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> ______________________________________________________________________ Get Your Own 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=coldfusionb 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
