You need to do a select distinct statement in your query.
SELECT DISTINCT FSA #, Franchise
Or use the Group By statement in your query (this is probably the better
answer)
<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
Group by FSA# or Franchise or whatever....it must be located before the
order by clause.
Order By Coname ASC
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
