I have a query that currently looks like:
CFQUERY name=clicks_per_product_market_display datasource=#
Data_Source #
select *
from email_results, email_blast
Where email_results.emres_blast_sent_id = #URL.BLAST# AND
email_results.emres_prod_catagory = '#get_cat_info.Category#' AND
[EMAIL PROTECTED]
I want companyA to show up only once even if they clicked 5 times. Does
that make sense?
Ben
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 11:43 AM
To: CF-Talk
Subject: RE: Group By Question
I have a query that currently
Why are you using GROUP BY if you dont have any aggregate functions in
your select clause (ie AVG() SUM() etc).
Try taking it out
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: 25 November 2003 16:45
To: CF-Talk
Subject: RE: Group By Question
Dave
use
MAX(columnname) as alias
along with your grouping.
dave
- Original Message -
From: Ben Densmore
To: CF-Talk
Sent: Tuesday, November 25, 2003 11:44 AM
Subject: RE: Group By Question
Dave,
That doesn't seem to do what I want it to. I modified the query to grab
just the fields I'm
That doesn't seem to do what I want it to. I modified the
query to grab just the fields I'm using and grouped by those
fields:
CFQUERY name=clicks_per_product_market_display datasource=#
Data_Source #
select
email_blast.embl_email,email_blast.embl_companyname,email_blas
5 matches
Mail list logo