RE: I Hate QoQ

[Tony Weeg]

whats a cfdump of the original query return?

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-----Original Message-----
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 4: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]

---