<CFQUERY name="clicks_per_product" datasource="#Data_Source#">
select Count(*) As Clicks,emres_prod_part_numl,
emres_prod_catagory
from email_results
Where emres_blast_sent_id = 23
GROUP BY emres_prod_part_numl, emres_prod_catagory
</CFQUERY>
Based on the current emres_blast_sent_id I get output that looks like
this:
Part Number Category Click Thrus
HMCXXXXX Amplifiers 389
HMCXXXXX Modulators - Direct 287
HMCXXXXX Modulators - Direct 132
HMCXXXXX Dividers & Detectors 125
This is all fine except the click thrus are off because of duplicate
entries. How can I get a distinct count on these? Using Count(*) is
counting every click thru and I only need it to count unique ones.
Thanks,
Ben
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
