Are you sure there isn't an error in one of the previous lines.
CF isn't always pointing at the line where the error actually occurred.
Pascal
> -----Original Message-----
> From: Michael Kear [mailto:[EMAIL PROTECTED]
> Sent: maandag 7 juni 2004 10:26
> To: CF-Talk
> Subject: QofQ problem - can you see what i've got wrong here please?
>
> 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]
