WHERE users.reviewCurrent = true I wonder if cfmx is choking on this line, have you put true in single quotes ?
..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:25 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? A dump of the first query produces the desired results. The datatype of team in a varChar(30) string. I have taken both queries into Query Analyzer, put the first inside of the second, and the correct results come out. It does not appear that there is anything wrong with the queries, at least from SQL Servers view. -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.