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
