-----Original Message-----
From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:32 PM
To: CF-Talk
Subject: CFMX/SQL Error
I am getting a very non-descript error in CFMX when doing a query on
query. Has anybody seen this error before? I have posted the CFMX/SQL
code below as well.
Thanks
----- Error Message -----
Error casting an object of type java.lang.boolean to an incompatible
type. This usually indicates a programming error in Java, although it
could also mean you have tried to use a foreign object in a different
way that it was designed.
-- Error line number indicates closing </cfquery> tag on second query --
----- CFMX / SQL Code -----
<cfquery name="summaryInfo" datasource="#request.dsn#">
SELECT systems.systemName, users.userID, users.name AS userName,
users.team, users.approval, users.comments
FROM systems INNER JOIN users ON systems.ownerID = users.userID
WHERE users.reviewCurrent = true
GROUP BY users.team, users.userID, users.name,
systems.systemName, users.approval, users.comments
ORDER BY users.team, users.name, systems.systemName
</cfquery>
<cfquery name="userList" dbtype="query">
SELECT DISTINCT userID, userName, team, approval, comments
FROM summaryInfo
WHERE team = 'marketing'
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
