On 6/12/01, W Luke penned:
>I'm trying to do the most basic of queries. Select distinct email addresses
>from a table, and email them using cfmail. But for some reason it's not
>pulling unique addresses - is this because I have a WHERE statement?
>
> <cfquery name="getothers" datasource="LBTalk">
> SELECT distinct comEmail, comDate FROM comments
> WHERE comEmail <> '#form.email#'
> AND comAdID = #form.adID#
> </cfquery>
>
>[EMAIL PROTECTED] has 4 entries with form.adID in the table comments - but
>he should only receive one email.
>
>Any suggestions appreciated
When you use DISTINCT, it will only bring up distinct records for the
fields you have defined. So in this case, if comDate is not also the
same for each record, then you have 4 distinct records.
Use <cfmail query="getothers" group="comEmail">
Then you can nest a cfoutput in the cfmail body if you want to show
all 4 comDates for that email address.
<cfmail query="getothers" group="comEmail"
from="blah"
to="blah"
subject="blah">
You received email on these dates:
<cfoutput>#dateformat(comDate)#
</cfoutput>
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
