I still don't see how the select list gets appended to?
<CFQUERY NAME="GetCartItems" datasource="#application.dsn#">
SELECT DISTINCT ItemIDPK, PartNum, ItemName, ItemCost, Quantity,
tblitems.itemsize AS ItemsItemSize,
tblitems.itemcolour AS ItemsItemColour,
tblCartItems.ItemSize AS CartItemsItemSize,
tblCartItems.ItemColour AS CartItemsItemColour
FROM tblItems, tblCartItems
WHERE itemID = ItemIDPK
AND CartIDPK = '#Cookie.CartID#'
</cfquery>From: Steve Powell <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> CC: Steve Powell <[EMAIL PROTECTED]> Subject: Re: [ cf-dev ] loop the loop loopiness Date: Fri, 16 Jul 2004 10:45:16 GMT
Looks to me like you are getting a cross product effect in one of your JOINS in a query and getting duplicate rows.
Look at the query as the cause of the problem. Try a DISTINCT or altering the JOIN criteria
regards
Steve
--
These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
