try the group attribute in <cfoutput> Corrine Clark <[EMAIL PROTECTED]> wrote: Actually I have no problem with my IFs, they do what I want, which is display the firstname of the person associated with the Dept. I want one table row for each Company number and Name on a line with the Responsibility, like so: FSC # Franchise Controller Analyst Revenue AP PayrollProcessor 95 2JR Tony Sheryl Vickie Tim Virginia Not each on its own line. And not all in one line. -----Original Message----- From: j p [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:42 PM To: CF-Talk Subject: Re: Database/CF easy problem for someone. I assume "I want it on one line" means the output...???(correct?) Try this...(putting the output loop inside the <tr> tags) <tr> <cfoutput query="getDeptR"> <td align="center">#NumberFormat(getDeptR.cono,'___')#</td> <td>#getDeptR.Coname#</td> <td><cfif #getDeptR.roleid# eq 9>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 10>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 1>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 3>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 2>#getDeptR.Firstname#</cfif></td> </cfoutput> <tr> ..... of course the will give you numerous table datas ... What are you trying to do with these IFs??? since you are outputing #getDeptR.Firstname# in every instance... they seem spufluous... HTH JP ----Original Message Follows---- From: Corrine Clark <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Database/CF easy problem for someone. Date: Mon, 14 May 2001 14:11:47 -0500 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for <[EMAIL PROTECTED]>; Mon, 14 May 2001 15:20:46 -0400 >From [EMAIL PROTECTED] Mon May 14 12:19:19 2001 Message-id: <850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2> I am pulling info from my database and trying to display in a table. Here is my code <cfquery name="getDeptR" datasource="fsc_intranet"> SELECT company.cono, company.coname, fsc_personnel.FirstName, fsc_personnel.employeeid, fsc_personnel.email, company_responsibility.cono, company_responsibility.roleid, company_responsibility.employeeid FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) ON [company].[CONO]=[company_responsibility].[CONO] Where company.cono > 0 Order By Coname ASC </cfquery> <table cellspacing="2" cellpadding="2" border="1"> <tr> <td>FSC #</td> <td>Franchise</td> <td>Controller</td> <td>Analyst</td> <td>Revenue</td> <td align="center">AP</td> <td>Payroll Processor</td> </tr> <cfoutput query="getDeptR"> <tr> <td align="center">#NumberFormat(getDeptR.cono,'___')#</td> <td>#getDeptR.Coname#</td> <td><cfif #getDeptR.roleid# eq 9>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 10>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 1>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 3>#getDeptR.Firstname#</cfif></td> <td><cfif #getDeptR.roleid# eq 2>#getDeptR.Firstname#</cfif></td> <tr> </cfoutput> </table> Here is what displays Department Responsibilities <<...>> FSC # Franchise Controller Analyst Revenue AP Payroll Processor 95 2JR Sheryl 95 2JR Vickie 95 2JR Crystal 95 2JR Tim 95 2JR Tony 69 AG Hospitalities Virginia 69 AG Hospitalities Charlie 69 AG Hospitalities Joanne 98 ALTES Darla 98 ALTES Vickie 98 ALTES Erin 98 ALTES Shannon 98 ALTES Chris And I want it on one line. Can anyone help? Corrine Clark 316-689-0049 x 383 -- NOTICE OF CONFIDENTIALITY ~~~~~~~~~~ This message and all attachments are confidential. It is intended only for the use of the person to whom it is addressed. If the message is not addressed to you, then you should immediately notify the sender and delete this message. Any use or retransmission of this message by a person other than the intended recipient is strictly prohibited and may violate state or federal law. Franchise Services Company, LLC, its subsidiaries, affiliates, and employees, do not accept liability for any errors, omissions, corruption or virus in the contents of this message or any attachments that arise as a result of e-mail transmission. ~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
