Well, one way it to use the DISTINCT keyword. Change your statement from:
SELECT Products.ItemID, etc.
to
SELECT DISTINCT Products.ItemID, etc.
.... but I'm not sure if that will give you what you want.
Give it a try and see what the result set looks like.
Bob
-----Original Message-----
From: Alan Koenig [mailto:[EMAIL PROTECTED]]
Sent: April 12, 2001 12:58 PM
To: CF-Talk
Subject: SQL Returns
I would like to refine my sql searches down. From the following sql
statement I am recieving up to 12 returns of the same record. How can I
make this so that there is only 1 return for each record?
<cfquery datasource="#datasource#" name="prodpage">
SELECT Products.ItemID,
Products.SKU, Products.ItemName,
Products.CategoryID,
Products.SubCatID,
Products.S_Description,
Products.Description,
Products.Price,
Products.Weight,
Products.A1,
Products.A1Vals,
Products.A2,
Products.A2Vals,
Products.Units,
Products.Layout,
Products.Key_Word,
ProdPics.PicID,
ProdPics.ItemPic,
ProdPics.ItemPicLB,
ProdPics.ItemPicF,
ProdPics.ItemPicB
FROM Products, ProdPics
WHERE Products.ItemID = ProdPics.PicID
AND Description LIKE '%#form.keyword#%'
OR ItemName LIKE '%#form.keyword#%'
AND ItemID > 1
ORDER BY ItemName
</cfquery>
TIA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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