possibilities, and I figure the problem might be something in the data
itself, causing the QofQ to hiccup.
Does anyone know what causes that error, "";;;;" must be interprettable as a
valid number in the current locale"?
Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
_____
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Monday, 7 June 2004 6:35 PM
To: CF-Talk
Subject: RE: QofQ problem - can you see what i've got wrong here please?
I can't see anything wrong with the code.
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]
