Group By Question

Hi, 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

RE: Group By Question

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

RE: Group By Question

[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

RE: Group By Question

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

Re: Group By Question

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

RE: Group By Question

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

Re: cfmail group attribute question

!doctype html public "-//w3c//dtd html 4.0 transitional//en" html Consider lt;CFMAIL to be an output tag itself. That'll fix it up! paslam bajaria wrote: blockquote TYPE=CITEHi All, brI am trying to have an email sent automatically. If I brhave the lt;cfmail tag in between lt;cfoutputlt;/cfoutput

Re: cfmail group attribute question

Whoops, Don't like those HTML emails - sorry people... What I was trying to say was the CFMAIL tag acts as a CFOUTPUT tag itself. Close the output tag before your cfmail tag. That'll work. aslam bajaria wrote: Hi All, I am trying to have an email sent automatically. If I have the cfmail

cfmail group attribute question(2)

:17 PM To: [EMAIL PROTECTED] Subject: cfmail group attribute question Hi All, I am trying to have an email sent automatically. If I have the cfmail tag in between cfoutput/cfoutput tags, then I get an error that says that I need the group attribute. If I have cfoutput

RE: cfmail group attribute question(2)

Can you have more than one email in the TO attribute of cfmail. If so, how. If I have a BCC, it is giving me an error as follows: Just in time compilation error An unknown attribute 'bcc' has been encountered at document position (14:6) to (14:8) while processing tag CFMAIL. This tag can

cfmail group attribute question

Hi All, I am trying to have an email sent automatically. If I have the cfmail tag in between cfoutput/cfoutput tags, then I get an error that says that I need the group attribute. If I have cfoutput/cfoutput in between cfmail and /cfmail tag, still I get the same error. I don't have a query. I

RE: cfmail group attribute question

Try it without the cfoutput tags. Brad -Original Message- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 15, 2000 4:17 PM To: [EMAIL PROTECTED] Subject: cfmail group attribute question Hi All, I am trying to have an email sent automatically. If I have