<cfquery name="shortlist" dbtype="query">
SELECT DISTINCT
email, Newsletter
FROM
Thislist
WHERE
Newsletter = 1
ORDER BY
</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]