I wrote the following page to make a many-to-many relationship for a site
search I need but when I test it it returns the product names several
time.something like this:
Product1Product1Product2Product2Product2Product1Product1Product3Product3Product3Product4Product4Product4Product4Product5Product5Product5Product5Product5Product5Product5Product5Product6Product6Product6
the comolete code is below. How can I filter the data that it return only one
copy of any product not two!
Thanks
Benifn
<cfquery name="test" datasource="mydatabase">
SELECT Companies.CompanyID, Companies.CompanyName, Companies.ManagerName,
Companies.SalesManagerName, Companies.CompanyCity, Companies.CompanyAdd,
Companies.CompanyDesc, Companies.CompanyRank,
Companies_Products.Companies_ProductsID, Companies_Products.CompanyID,
Companies_Products.ProductID, Products.ProductID, Products.ProductName,
Products.ProductDesc, Products.ProductImage, Products.ProductTypeID
FROM Companies AS Companies, Companies_Products AS Companies_Products, Products
AS Products
WHERE Products.ProductID = Companies_Products.ProductID
and Companies.CompanyID = Companies_Products.CompanyID;
</cfquery>
<html xmlns="http://www.w3.org/1999/xhtml";>
<body>
<cfoutput query="test">#ProductName#</cfoutput>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
