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]

