Paul, does tblItems have a seperate row for each colour, and each size?
e.g.
Shoe 1, Red, size 3
Shoe 1, Red, size 4
Shoe 1, Red, size 5
Shoe 1, Black, size 3
Shoe 2, Black, size 3
Shoe 2, Black, size 3
etc etc?
"Paul Swingewood"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: Re: [ cf-dev ] loop the
loop loopiness
16/07/2004 11:47
Please respond to
dev
The query is simple enough really .... (I would have thought this was all
ok
....)
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]
--
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]
