Re: I Hate QoQ

[Bryan Stevenson]

and you're absolutely sure that the query you are querying returns a 1 or 0 for isPrivate (show us the dump of the first query)?  Could isPrivate ever be NULL?

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
  ----- Original Message -----
  From: Adam Wayne Lehman
  To: CF-Talk
  Sent: Monday, December 08, 2003 1:54 PM
  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]

---