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]
- I Hate QoQ Adam Wayne Lehman
- RE: I Hate QoQ Tony Weeg
- RE: I Hate QoQ Adam Wayne Lehman
- RE: I Hate QoQ Greg Luce
- RE: I Hate QoQ Adam Wayne Lehman
- RE: I Hate QoQ Sandy Clark
- Re: I Hate QoQ Bryan Stevenson
- RE: I Hate QoQ Barney Boisvert
- RE: I Hate QoQ Jochem van Dieten
- RE: I Hate QoQ Sandy Clark
- RE: I Hate QoQ Robert Segal
- RE: I Hate QoQ Stacy Young
- RE: I Hate QoQ Adrian Lynch
- RE: I Hate QoQ Smith, Matthew P -CONT(CSC)
- RE: I Hate QoQ DURETTE, STEVEN J (AIT)
- RE: I Hate QoQ Adam Wayne Lehman
- RE: I Hate QoQ Adam Wayne Lehman
- RE: I Hate QoQ Adrian Lynch
- RE: I Hate QoQ DURETTE, STEVEN J (AIT)