RE: Anybody up for a non-descript CFMX error?
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. ~| 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
RE: Anybody up for a non-descript CFMX error?
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. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:30 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? Are you using the ODBC Bridge or the other drivers? At 02:27 PM 12/5/2002 -0600, you wrote: >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: > > > > > 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 > > > > 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 tag on second query > >-- > > > >- CFMX / SQL Code - > > > > > > 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 > > > > > > > > SELECT DISTINCT userID, userName, team, approval, comments > > FROM summaryInfo > > WHERE team = 'marketing' > > > > > > > > > > ~| 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.
RE: Anybody up for a non-descript CFMX error?
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 mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:26 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? 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 tag on second query -- - CFMX / SQL Code - 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 SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' ~| 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
RE: Anybody up for a non-descript CFMX error?
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 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 3:26 PM To: CF-Talk Subject: RE: Anybody up for a non-descript CFMX error? 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 tag on second query -- - CFMX / SQL Code - 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 SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' ~| 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
RE: Anybody up for a non-descript CFMX error?
Are you using the ODBC Bridge or the other drivers? At 02:27 PM 12/5/2002 -0600, you wrote: >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: > > > > > 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 > > 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 tag on second query > >-- > > > >- CFMX / SQL Code - > > > > > > 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 > > > > > > SELECT DISTINCT userID, userName, team, approval, comments > > FROM summaryInfo > > WHERE team = 'marketing' > > > > > > > > > > ~| 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.
RE: Anybody up for a non-descript CFMX error?
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 tag on second query -- - CFMX / SQL Code - 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 SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' ~| 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.
RE: Anybody up for a non-descript CFMX error?
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: > > 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 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 tag on second query >-- > >- CFMX / SQL Code - > > > 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 > > > SELECT DISTINCT userID, userName, team, approval, comments > FROM summaryInfo > WHERE team = 'marketing' > > > > ~| 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
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 tag on second query -- - CFMX / SQL Code - 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 SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' ~| 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.
Re: Anybody up for a non-descript CFMX error?
How much description do you want? I bet the problem is with this query: > > 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 > 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 tag on second query -- > >- CFMX / SQL Code - > > > 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 > > > > SELECT DISTINCT userID, userName, team, approval, comments > FROM summaryInfo > WHERE team = 'marketing' > > > > ~| 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
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 tag on second query -- - CFMX / SQL Code - 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 SELECT DISTINCT userID, userName, team, approval, comments FROM summaryInfo WHERE team = 'marketing' ~| 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