How much description do you want? I bet the problem is with this query: ><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>
Is users.reviewCurrent a bit field? Or a text field? If it is a bit field use 1 or 0. If it is a text field use 'true' At 02:13 PM 12/5/2002 -0600, you wrote: >-----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