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.