lemme see your output code. that may be the problem
----- Original Message -----
From: "Greg Wolfinger" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 04, 2000 3:55 PM
Subject: getting only unique query results
> Hey Guys:
>
> I have a query that looks likes this:
>
> <cfquery name="qFoo" datasource="#application.ds#">
> SELECT name, product_id
> FROM tblProducts
> WHERE category_id = '0000'
> <cfloop list="#attributes.theList#" delimiters="," index="theID">
> OR category_id = '#theID#'
> </cfloop>
> </cfquery>
>
> The problem is that it keeps on selecting the products over and over and
not just once. I have only 11 records for it to try and select, but it
comes back to give me 484. Anyone know why this is happenening???
>
> Thanks,
>
>
>
> Greg
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
