reviewCurrent is a bit field. I change the query to use 1 instead of true. The same error occurs. As I mentioned on the previous message, I can put both queries (separate or nested) into Query Analyzer and they both work. It does not seem like an SQL error, but the CFMX error is not real clear.
-----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:17 PM To: CF-Talk Subject: Re: Anybody up for a non-descript CFMX error? 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 Get the mailserver that powers this list at http://www.coolfusion.com
