CF recordsets aren't strongly typed, but the comparisons are. Most of the
problems I've had are because one field in one record has an ambigious type,
and it screws everything up. Also, I'm not sure passing '1' is going to
make it a character comparison. The sql interpreter might convert it to
numeric behind the scenes, before the query is run.
Cheers,
barneyb
> -----Original Message-----
> From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 08, 2003 1:55 PM
> To: CF-Talk
> Subject: I Hate QoQ
>
> So any idea why this very simple QoQ won't work?
>
> <!---- filter query ---->
> <cfquery dbtype="query" name="involved">
> SELECT isPublic FROM involved
> WHERE isPublic = 1
> </cfquery>
>
> isPublic is a valid column name, and the values are either 0 or 1.
>
> This is the error I get:
>
> Query Of Queries runtime error.
> Unsupported Date type conversion in Query of Queries.
>
> I've tried the follow too in case some reason it converted to string,
> but alas same error:
>
> <!---- filter query ---->
> <cfquery dbtype="query" name="involved">
> SELECT isPublic FROM involved
> WHERE isPublic = '1'
> </cfquery>
>
> Any ideas?
>
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
