Adrian Lynch wrote:
> Can you change the query to use joins instead?
I haven't quite worked that out yet because of the way the two queries
were originally set up:
-----------------------
QUERY ONE:
-----------------------
SELECT DISTINCT
groups_id,
ml_id
FROM nl_catREL
WHERE groups_id = #form.sendGROUP# AND ml_id IS NOT NULL
-----------------------
QUERY TWO:
-----------------------
SELECT
max(ml_id) as ml_id,
max(ml_firstname) as ml_firstname,
max(ml_lastname) as ml_lastname,
max(other) as other,
ml_email
FROM nl_mailgroups
WHERE ml_id IN (
<cfqueryparam value="#ValueList(GetGROUP.ml_id)#,0"
cfsqltype="CF_SQL_INTEGER"
list="yes" /> )
GROUP BY ml_email
ORDER BY ml_email
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319699
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
