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: > > ><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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
