RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeff D. Chastain
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

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeff D. Chastain
. -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

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeff D. Chastain
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

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Tony Weeg
, 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

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeffry Houser
nto 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: Anyb

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Tony Weeg
. 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

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeff D. Chastain
. -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: > >

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeff D. Chastain
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

Re: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Jeffry Houser
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.review

RE: Anybody up for a non-descript CFMX error?

2002-12-05 Thread Tony Weeg
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: Je