Hi,
I'm having a nightmare today - it's like banging my head against a CF wall..
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
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
