Question
How To Use QoQ For Group By Count
Ok, I am having a issue with Group By and Count. Basically, here is what i am working with...
<cfquery name="TEST" datasource="MyDataSource">
SELECT
ContentID, ContentName, ProductID
FROM
MyTable
</cfquery>
HERE IS AN EXAMPLE DUMP
1, ABCD, 33
1, ABCD, 34
1, ABCD, 35
1, ABCD, 36
1, ABCD, 37
2, EFG, 342
2, EFG, 343
2, EFG, 344
2, EFG, 345
2, EFG, 346
2, EFG, 347
2, EFG, 348
3, HIJK, 101
3, HIJK, 102
3, HIJK, 103
Then I run this query on it.
<cfquery name="MYGROUPLIS" dbtype="query">
SELECT
ContentID, ContentName, COUNT(ProductID)
FROM
TEST
GROUP BY
ContentID, ContentName
</cfquery>
It Should be this:
1, ABCD, 5
2, EFG, 7
3, HIJK, 3
But instead i get this:
1, ABCD, 12
1, EFJ, 12
1, HIJK, 12
WHY?????
AdChoices