This Query of a Query is giving an error I've never seen before.   Can
anyone see what's causing it please?  

The QofQ is as follows:

[quote]

<cfquery name="shortlist" dbtype="query">

SELECT DISTINCT(email)

FROM Thislist

WHERE Newsletter = 1

ORDER BY email

</cfquery>

[/quote]

And I've checked, those fields exist in the query, and I can CFDUMP the
query ThisList without problems.  All the fields referred to in the QofQ
exist in the first query and have values.

The error I'm getting is:

[quote]

";;;;" must be interprettable as a valid number in the current locale.

Pointing to the line containing:
<cfquery name="shortlist" dbtype="query">

[/quote]



Cheers

Mike Kear

AFP Webworks

Windsor, NSW, Australia

http://afpwebworks.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to