Anybody up for a non-descript ColdFusion MX 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>

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 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>

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. 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 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>

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 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. 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 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>

nevermind, just saw your post back explaining this datatype. sorry. ...tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 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 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. 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 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>

Has anybody even seen this error message before? ----- 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.

reviewCurrent is a bit field - therefore true or 1 should work (without quotes) - both of which have been tried. The error message is being thrown on the second query (QofQ).  I successfully utilize the first query in the page before the QofQ and it works fine.  I have done a <cfdump on the first query right before the QofQ call and it looks exactly as expected. 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 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. 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 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>

  How much description do you want?  I bet the problem is with this query: ----- Excess quoted text cut - see Original Post for more -----   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: ----- Excess quoted text cut - see Original Post for more -----

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.   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: ----- Excess quoted text cut - see Original Post for more ----- users.userID ----- Excess quoted text cut - see Original Post for more -----

  Are you using the ODBC Bridge or the other drivers? At 02:27 PM 12/5/2002 -0600, you wrote: ----- Excess quoted text cut - see Original Post for more -----

ODBC Socket However, other queries against the same datasource are coming through just fine.  The first (main query) is used in several other pages (same app, same datasource) without any problem.  The error  is occurring with the QofQ, which should not be datasource dependant at all.   Are you using the ODBC Bridge or the other drivers? At 02:27 PM 12/5/2002 -0600, you wrote: ----- Excess quoted text cut - see Original Post for more -----