Have you tried...

<cfquery name="shortlist" dbtype="query">
SELECT DISTINCT
email, Newsletter
FROM
Thislist
WHERE
Newsletter = 1
ORDER BY
email
</cfquery>

We're on CF5 and QoQ and AFAIK it always chokes unless you explicity use
all the columns that you reference..... just a thought :-/

--
dc
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to