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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
