take out your 2nd <tr> from inside the loop
<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>
Corrine Clark <[EMAIL PROTECTED]> wrote:
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
