does the first query work? can you do a dump of the first and see correct results? also, what datatype is the column "team"?
..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -----Original Message----- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:14 PM To: CF-Talk Subject: Anybody up for a non-descript CFMX error? -----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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
