RE: I Hate QoQ

[Smith, Matthew P -CONT(CSC)]

I had some trouble getting QofQ to work with bit data types way back when.  I don't think we ever resolved it and just went to tinyint in the db.  Has anyone ever gotten bit datatypes to work in QofQ?  Is there some work around?


Thanks,

-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 7:29 AM
To: CF-Talk
Subject: Re: I Hate QoQ


Adam Wayne Lehman wrote:
> 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.

Probably the ugly under-the-hood typeacsting again. How about
trying for a boolean:
<cfquery dbtype="query" name="involved">
   SELECT isPublic FROM involved
   WHERE isPublic = TRUE
</cfquery>

Jochem

--
When you don't want to be surprised by the revolution
organize one yourself
     - Loesje
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---